Forum Discussion
Solved
Rank x
Hi All, I'm Looking at creating a ranking system that ranks a store by all Months Store Name Month Rank Store 1 Aug 1 Store 1 Sep 2 Store 1 Oct 2 Store 1 Nov 1 ...
Hi JamesBurke
You can refer to the following solution.
Sample data
You can create a measure
MEASURE = RANKX ( ALLSELECTED ( 'Table'[Store Name], 'Table'[Month] ), CALCULATE ( SUM ( 'Table'[Usage] ) ), , ASC, DENSE )Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi JamesBurke
You can refer to the following solution.
Sample data
You can create a measure
MEASURE =
RANKX (
ALLSELECTED ( 'Table'[Store Name], 'Table'[Month] ),
CALCULATE ( SUM ( 'Table'[Usage] ) ),
,
ASC,
DENSE
)
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.