Ranking data with certain filters

Question

I have data that I want to rank with filters within the DAX formula. I need a DAX formula which lets me rank 'Branches' in the 'North' cluster for the month of 'October'.Data Preview:Branch&nbsp; &nbsp; &nbsp;Score&nbsp; &nbsp; &nbsp; &nbsp;Month&nbsp; &nbsp; &nbsp;Cluster1001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;70&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Sept&nbsp; &nbsp; &nbsp; &nbsp;North1002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;76&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Sept&nbsp; &nbsp; &nbsp; &nbsp;South1003&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;77&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Sept&nbsp; &nbsp; &nbsp; &nbsp;North1004&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;72&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Sept&nbsp; &nbsp; &nbsp; &nbsp;North1005&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;56&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Sept&nbsp; &nbsp; &nbsp; &nbsp;South1001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;74&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Oct&nbsp; &nbsp; &nbsp; &nbsp; North1002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;73&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Oct&nbsp; &nbsp; &nbsp; &nbsp; South1003&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;78&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Oct&nbsp; &nbsp; &nbsp; &nbsp; North1004&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;69&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Oct&nbsp; &nbsp; &nbsp; &nbsp; North1005&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;54&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Oct&nbsp; &nbsp; &nbsp; &nbsp; SouthRequired:Ranking of Branches of North cluster for October1&nbsp; &nbsp; &nbsp; 1003&nbsp; &nbsp; &nbsp; 782&nbsp; &nbsp; &nbsp; 1001&nbsp; &nbsp; &nbsp; 743&nbsp; &nbsp; &nbsp; 1004&nbsp; &nbsp; &nbsp; 69Please help!

icey · Accepted Answer

Hi&nbsp;danialsj&nbsp;,You can create your measure like so:&nbsp;Rank = 
RANKX (
    ALLSELECTED(  'Table' ),
    CALCULATE ( MAX ( 'Table'[Score] ) ),
    ,
    DESC,
    DENSE
)&nbsp;&nbsp;&nbsp;Best Regards,Icey&nbsp;If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

Ranking data with certain filters

2 Replies

Related content

Filter by Rank measure

Duplicate ranking

Rank Issue - Table vs Filter Results

Rank with conditions

Dynamic Ranking