Forum Discussion

JamesBurke's avatar
JamesBurke
Helper III
2 years ago
Solved

Rank x

Hi All, 

 

I'm Looking at creating a ranking system that ranks a store by all Months 

 

Store NameMonth Rank
Store 1Aug1
Store 1Sep2
Store 1Oct2
Store 1Nov1
Store 1Dec1

 

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.  

Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

     

     

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.