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
hnguy71's avatar
hnguy71
Super User
3 years ago

bdehning that's correct.

 

You need both the sum and the count. One of the two will act as your tiebreaker.

bdehning's avatar
bdehning
Post Prodigy
3 years ago

I appreciate your help.

 

But we actually want to find the top 5 by count first and then use the Sum of Total Gross as tie breaker.    If Top 5 is found 1-5, then no Sum is needed.  

 

If we get the Top Part working above and you understand how I need Sum to be used, we could be getting close