Rankx TOP 5 Value Help

Hello bdehning,

If ALL or ALLSELECTED is used in RANKX, the filtering behavior in charts can differ, leading to missing or unexpected results. Can you please try this approach:

Ranked Cities = 
VAR _TopCities = 
    ADDCOLUMNS (
        SUMMARIZE (
            LossRun,
            LossRun[Reporting Location City]
        ),
        "@Rank", RANKX (
            ALL(LossRun[Reporting Location City]),
            [Count of Total Gross Incurred],
            ,
            DESC,
            DENSE
        )
    )
RETURN
    IF (
        LOOKUPVALUE ( "@Rank", _TopCities, LossRun[Reporting Location City] ) <= 5,
        [Count of Total Gross Incurred]
    )

Ranked Causes = 
VAR _TopCauses = 
    ADDCOLUMNS (
        SUMMARIZE (
            LossRun,
            InjuryCause[Cause Grouping],
            LossRun[Reporting Location City]
        ),
        "@Rank", RANKX (
            FILTER (
                ALLSELECTED ( InjuryCause[Cause Grouping] ),
                LossRun[Reporting Location City] = SELECTEDVALUE ( LossRun[Reporting Location City] )
            ),
            [Sum of Total Gross Incurred],
            ,
            DESC,
            DENSE
        )
    )
RETURN
    IF (
        LOOKUPVALUE ( "@Rank", _TopCauses, InjuryCause[Cause Grouping], LossRun[Reporting Location City] ) <= 5,
        [Sum of Total Gross Incurred]
    )