Forum Discussion
Rank Measure
bdehning it would just be replaced by your sum of total gross incurred. This would be then your tiebreaker value.
[Count of Total Gross Incurred] + [Sum of Total Gross Incurred],
Working on it. Do cRecord and tmpRank need to be columms or can they be measures?
- hnguy713 years agoSuper User
bdehning since you're not using the tiebreaker variable, you can get rid of it all
IF( ISINSCOPE( 'InjuryCause'[Cause Grouping]), RANKX ( CALCULATETABLE ( VALUES ( 'InjuryCause'[Cause Grouping]), ALLSELECTED ( 'InjuryCause'[Cause Grouping] ) ), [Count of Total Gross Incurred] + [Sum of Total Gross Incurred], , DESC, DENSE ) ) - bdehning3 years agoPost Prodigy
I would need a tie breaker though as original data from Count only is
1
2
3
4
5
5
5
5
5
I ran the above and it ran and gave results of ranking I was looking, but is it only adding the Sum to the count and then ranking and we only got lucky? I do need the [Sum of Total Gross Incurred] as tie breaker if Count results in ties.
- bdehning3 years agoPost Prodigy
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