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

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.

JellyFishBi's avatar
JellyFishBi
Helper I
7 years ago

Ashish_Mathur 
I can send the file again.  Do you still have it from yesterday??

 

 

  • rcorn's avatar
    rcorn
    Frequent Visitor
    3 years ago

    Hi - By any chance did you ever find a solution to this problem?