Forum Discussion

bprokop's avatar
bprokop
Frequent Visitor
2 years ago
Solved

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's avatar
    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?

littlemojopuppy's avatar
littlemojopuppy
Community Champion
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?