Rank x

[JamesBurke]

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
Store 1	Dec	1

Something like above i want to rank stores based on their  total usages by Month so as a result i can create a Matrix table that says store 1 has been rank 1 x amount of times. 

Thanks , James.  

[v-xinruzhu-msft · Accepted solution]

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.