Forum Discussion
Solved
Rank by multiple values
Hello everyone! Any help will be appreciated in the next question I have 3 tables: 1. Sales (date, customer ID, product ID, sales $) 2. Calendar (dates, months & so on) 3. Products (produc...
Hi D3K ,
That measure in the demo could be the customer level measure. Please try out this one as a company level rank measure.
CompanyLevelRank = RANKX ( ALL ( DimProduct[ProductKey] ), CALCULATE ( SUM ( FactSales[SalesQuantity] ), ALL ( DimCustomer[CustomerLabel] ) ) )
Best Regards,
Hi D3K ,
One measure is enough. You can change the context to get what you want. Please download the demo from the attachment.
Measure = RANKX ( ALL ( DimProduct[ProductKey] ), CALCULATE ( SUM ( FactSales[SalesQuantity] ) ) )
Best Regards,
Hi v-jiascu-msft Dale,
thank you for your answer. I've tried a hundreds of formula combinations, but the thing is the context :)
My problem was to get 1 common table of the next type:
Will use your solution with 2 tables, but maybe is it the way to create such table as I've described before?
Thanks a lot!
Hi D3K ,
That measure in the demo could be the customer level measure. Please try out this one as a company level rank measure.
CompanyLevelRank = RANKX ( ALL ( DimProduct[ProductKey] ), CALCULATE ( SUM ( FactSales[SalesQuantity] ), ALL ( DimCustomer[CustomerLabel] ) ) )
Best Regards,
