Forum Discussion

spencer_II's avatar
spencer_II
Helper I
9 years ago
Solved

RANKX Not Working

Okay... have spent a few hours in forumns reviewing a myriad of patterns for RankX. Basic, advanced, using filters, AllSelected, ETC, ETC and still my table shows 1's for every line. I have built sim...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi spencer_II,

    AND SOLVED... Love it when the answer is finally discovered.  Here is the fix///

     

    EQ Vol Rank = If(HASONEVALUE('PQ BI Data'[Descript Final]),Rankx(all('PQ BI Data'[Descript Final]),[Total EQ]) )

    Great to hear the problem got resolved!

     

    To close this thread, and help others who may also have this similar issue easily find the answer, I have quoted your solution and marked it as answer. :smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi spencer_II,

AND SOLVED... Love it when the answer is finally discovered.  Here is the fix///

 

EQ Vol Rank = If(HASONEVALUE('PQ BI Data'[Descript Final]),Rankx(all('PQ BI Data'[Descript Final]),[Total EQ]) )

Great to hear the problem got resolved!

 

To close this thread, and help others who may also have this similar issue easily find the answer, I have quoted your solution and marked it as answer. :smileyhappy:

 

Regards