Forum Discussion

JellyFishBi's avatar
JellyFishBi
Helper I
7 years ago
Solved

Ranking changes when applying filters

Good Evening Folks.  My Problem with RANKX is that It ranks my list just fine as shown: BUT When I filter by a Provider, "Reem" in this case, His rank drops to 2 as shown. My Formula is...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    This measure solves the problem

    RankProdHr = IF(HASONEVALUE(BizLine[ProvName]),RANKX(ALLSELECTED(BizLine[ProvName]),[Prod/Hr]))
    Hope this helps.
Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

You are welcome.  To pay heed to the specific Clinic names chosen in the slicer.

JellyFishBi's avatar
JellyFishBi
Helper I
7 years ago

Ashish_Mathur 

 

New Problem has arisen.  When I select any other provider with the slicer, they all are ranked 1.  I need them to maintain their rank when filtered by slicer.  How to cope with this?

 

Man thanks,

Mike

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Cannot understand.  Show the exact problem and also the expected result.

    • JellyFishBi's avatar
      JellyFishBi
      Helper I
      7 years ago

      Thanks for the response.

       

      As you can see, the provider Rubis is ranked 2 prior to any filtering and then when filtered to his name, he is ranked 3.

       

       

      Afer Filtering, His rank Increases to 3.

      I Would like his rank to maintain the rank of 2. 

       

      My Current formula for this is: 

      RankProdHr = IF(HASONEVALUE(BizLine[ProvName]),RANKX(ALL(BizLine[ProvName]),[Prod/Hr]))
       
      Using ALLSELECTED returns the Rank to 1 when filtered which is not the desired outcome.
       
      My thanks.
       
       

       

       

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        7 years ago

        Hi,

        Try this measure

        =IF(HASONEVALUE(BizLine[ProvName]),RANKX(CALCULATETABLE(ALL(BizLine[ProvName]),ALLSELECTED(BizLine[ClientName])),[Prod/Hr]))

        If it does not, share the link from where i can download your PBI file.