Forum Discussion
Rankx TOP 5 Value Help
I want Top 5 Reporting Location Cities by Count and for each City the Top 5 Cause by Count and break ties by using Total Incurred This is used to get Reporting Location City using Top N a...
I forgot to include another measure that is used inside both Measures above that may impact your solution.
Ref =
VAR _MX =
MAXX (
ALL ( InjuryCause[Cause Grouping] ),
CALCULATE ( SUM ( LossRun[Total Gross Incurred] ) )
)
VAR _LNGTh =
LEN ( FORMAT ( INT ( _MX ), "Text" ) ) + 1
RETURN
COUNT ( LossRun[Total Gross Incurred] ) * POWER ( 20, _LNGTh )
+ SUM ( LossRun[Total Gross Incurred] )