Ranking based on two dimensions

[SriGaG]

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 report by count of views. I have tried so hard and i cannot achieve it.. Can anyone help me? The below is the snapshot of my requirement. Im using a direct query environment. so i cannot use functions suc as earlier.

report	user	count of views	required rank
R1	U1	3	4
R1	U2	4	3
R1	U3	2	5
R1	U4	5	2
R1	U6	7	1
R1	U8	2	6
R2	U1	6	1
R2	U3	2	3
R2	U4	3	2

ranking method need to be unique ranking. Can anyone help me. This is little bit urgent

[v-cgao-msft · Accepted solution]

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]

Hi,

Assuming Count of value is a measure, write this measure

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

Hope this helps.

[SriGaG]

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]

Share the download link of the PBI file.