Forum Discussion

SriGaG's avatar
SriGaG
Frequent Visitor
2 years ago
Solved

Ranking based on two dimensions

Hi Experts   I have an issue in ranking   I have a table which contains three columns. first is Reportname, second is userid, third is count of views. What i need is i neeed to rank the user repo...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi SriGaG ,

    Please try:

    ranking = RANKX(FILTER(ALL('Table1'),'Table1'[report]=MAX('Table1'[report])),[count of views],,DESC,Dense)

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

Hi,

Assuming Count of value is a measure, write this measure

Measure = rankx(all(Data[user]),[Count of value])

Hope this helps.

SriGaG's avatar
SriGaG
Frequent Visitor
2 years ago

Thank you ashish for the prompt response . I have tried this Calc so many times. But not givin the desired outcome . I have several filters applied for the visual too. But this isn't working . 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Share the download link of the PBI file.