Forum Discussion

bdehning's avatar
bdehning
Post Prodigy
3 years ago

Rank Measure

I have this measure    Rank Product = IF (     ISINSCOPE( 'InjuryCause'[Cause Grouping]),     RANKX (         CALCULATETABLE (             VALUES ( 'InjuryCause'[Cause Grouping]),        ...
Need Help
bdehning's avatar
bdehning
Post Prodigy
3 years ago

I have reworked the measure and now I have this

 

Rank Cause Grouping Count =
RANKX(
   
        ALLSELECTED(InjuryCause[Cause Grouping]),
        CALCULATE(
           COUNT(LossRunToExcel[Total Gross Incurred])),
        ,
        DESC, Dense
      )
 
Now I just need to come up with the rest to break ties and I want to use SUM(LossRunToExcel[Total Gross Incurred] to break the ties.