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

  • hnguy71's avatar
    hnguy71
    Super User
    3 years ago

    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],

     

    • bdehning's avatar
      bdehning
      Post Prodigy
      3 years ago

      Working on it.  Do cRecord and tmpRank need to be columms or can they be measures?

      • bdehning's avatar
        bdehning
        Post Prodigy
        3 years ago
        Second Return says Unexprected Return

            RETURN _tmpRank
        ,
        RETURN
    • bdehning's avatar
      bdehning
      Post Prodigy
      3 years ago

      Working on it.  Do cRecord and tmpRank need to be columms or can they be measures?

      • hnguy71's avatar
        hnguy71
        Super User
        3 years ago

        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
    )
)