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:

RankProdHr = IF (
    HASONEVALUE (
        BizLine[ProvName] ),
    RANKX(
         ALL (
             BizLine[ProvName]),NetProd[Prod/Hr]))

Any help would be appreciated.  I have adjusted this formula to exclude HASONEVALUE, i've included dense, skip.  All produce the same behavior...


Thanks,

Mike









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.

16 Replies