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 ,

 

cRecord is just a variable name. You can call it whatever you want, but i'm labeling it as cRecord to indicate that it is the current record on the visual.

 

The divide is used to convert a whole number into a decimal number. The tiebreaker looks at all visible output and returns a tiebreaker score starting from 1 and upwards until your last visible record.

 

If you break down the output it would be something simlar (considering lowest count is ranked 1):

 

1 + 1/100 = Rank 1
2 + 2/100 = Rank 2
3 + 3/100 = Rank 3
4 + 4/100 = Rank 4
5 + 5/100 = Rank 5
5 + 6/100 = Rank 6
5 + 7/100 = Rank 7
5 + 8/100 = Rank 8
5 + 9/100 = Rank 9
bdehning's avatar
bdehning
Post Prodigy
3 years ago

Having a hard time in getting this to work .  We would need to use the Sum of Total Gross Incurred for each Cause Group to break the tie. 

 

[Count of Total Gross Incurred] + DIVIDE(_TieBreaker, 100),

 

How could the Divide be swapped out to use the Sum of Total Gross Incurred for each Cause Group