Display Rank Value In A Card While Including and Excluding Slicers

In the attached PBIX, I am trying to create a measure for the Dynamic Rank All Card that will display the Rank for the Hospital ID but all it to change based on any other Slicer Selected. Currently,...

Need Help

littlemojopuppy

2 years ago

Morning bprokop

Try this measure...

VAR SelectedHospitals =
    CALCULATETABLE (
        ALLSELECTED ( Data ),
        REMOVEFILTERS ( Data[Hospital ID] )
    )
RETURN
    RANK (
        SKIP,
        SelectedHospitals,
        ORDERBY ( Data[National Rank], ASC )
    )

I think this is the desired result?

Forum Discussion

Display Rank Value In A Card While Including and Excluding Slicers

Related content

Mass Filter (should not include Exclude option)

Include/Exclude Slicer

Exclude and Include Data

Include/Exclude Option - remove it

Slicer that excludes instead of includes