Forum Discussion
Rank Measure
I have this measure Rank Product = IF ( ISINSCOPE( 'InjuryCause'[Cause Grouping]), RANKX ( CALCULATETABLE ( VALUES ( 'InjuryCause'[Cause Grouping]), ...
Second Return says Unexprected Return
RETURN _tmpRank
,
RETURN
Almost there but I have this
VAR _TieBreaker =
IF(
ISINSCOPE('InjuryCause'[Cause Grouping]),
VAR _cRecord = MAX('InjuryCause'[Cause Grouping])
VAR _tmpRank = COUNTROWS( FILTER(ALL('InjuryCause'), 'InjuryCause'[Cause Grouping] >= _cRecord ))
RETURN _tmpRank
,
RETURN
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
)
)
It is not getting past the 2nd return as it says Unexpected Return?