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?

bprokop's avatar
bprokop
Frequent Visitor
2 years ago

Hi Ashish,

 

That appears to be one of the older files I had posted with a different question.  The file should be the one labeled Sample Data - Dynamic Rank.  I checked the google drive link and it brought me to the file.  Below is what you should see when opened.

 

Thanks

 

Brian

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

I still see the same old file there.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      2 years ago

      Am unable to solve it.

      • littlemojopuppy's avatar
        littlemojopuppy
        Community Champion
        2 years ago

        Ashish_Mathur that is so unlike you!  You usually clear up the last few details after someone else does the heavy work!  Take your moment, dig in and fix this!!!  Shine, brother, shine!  ğŸ˜„

         

        bprokop do me a favor.  PM me with the details and the ability to download some data to play with this.  I'll solve this.