As I am practising along with what I am learning here, I want to display a report which shows the product that had the most Sales Quantity per Customer Area and it’s percentage contribution to total sales products, slicing data by year.
I have tried:
Rank Sales QTYs = IF ( ISINSCOPE ( SummarizeTab[Product Name] ), RANKX ( ALLEXCEPT ( SummarizeTab, SummarizeTab[Product Name] ), SUMX(SummarizeTab, SummarizeTab[Sales QTYs] ) ), IF ( ISINSCOPE ( SummarizeTab[Customer Area] ), RANKX ( ALLSELECTED ( SummarizeTab[Customer Area] ), SUMX(SummarizeTab, SummarizeTab[Sales QTYs] ) ) ) )
I also tried SUMMARIZECOLUMNS to bring in the columns from various tables, sorting it by region and by sales before finding the percentage contribution but that did not work
SummarizeTab = SUMMARIZECOLUMNS( Customers[Customer Area], Products[Product Name], "Sales QTYs", [Transaction] )
I do honestly need your help.
My .pbix is at https://1drv.ms/u/s!Aj8eUM9XW8iTgddz-WpFw7RFTWhfKA?e=DzCXcX
Product Sales and Perc Contribution.pbix (284.3 KB)