Forum Discussion
TopN with Multiple Dimensions
Hi there clever people! I have a ranking situation that I am trying to solve and have approached it from 5 different ways and reach the same result every time, so I may be about to go insane. Ho...
Here's the solution.
Best
D
- Well, my solution has the advantage that it can be used in ANY visual and restrict stores even if other measures used in there return values for all stores.
Best
D
Here's the solution.
Best
D
Thank you very much, D
I also got the following solution from another site that worked well too:
Rank Stores = VAR Top5Stores = CALCULATETABLE ( TOPN ( 5, CALCULATETABLE ( VALUES ( Locations[Store Name] ) ), [Weeks of Sales] ), ALLSELECTED() ) RETURN CALCULATE ( [Weeks of Sales], KEEPFILTERS ( Top5Stores ) )
Cheers,
Phil
- Well, my solution has the advantage that it can be used in ANY visual and restrict stores even if other measures used in there return values for all stores.
Best
D Can you share the website where you got this solution?
