How to use dax function to create bar chart and show rank?

[xiumi_hou]

Dear all, 

I have below measure, the y-axis is person name, and bar is the count numbers

Completed Cases =

CALCULATE(

DISTINCTCOUNT(d_Cases[CaseNumber])+0,

d_Cases[Closure Reason] = "Completed",

USERELATIONSHIP(d_Cases[Closed_date_c],d_date[Date]),

USERELATIONSHIP(d_Cases[Assigned_user_id],d_users[id])

)

How can I revise ablove dax to show thr rank of each person? 

For example, I have 5 people their score are 10,10,9,8,4

I would like to see their rank as 1,1,3,4,5

Thank you so much!

[v-diye-msft]

Hi @xiumi_hou 

You need to refer to the RANKX function, please see: https://docs.microsoft.com/en-us/dax/rankx-function-dax 

Try below measure:

measure = RANKX(all(table),[Completed Cases],,DESC)

If it doesn't meet your requirement, please share your dummy pbix that I can look into it.

[xiumi_hou]

UP