ranking one column grouped by another column

[umutkoyun]

hi all,

I am trying to rank accounts grouped within their categories. I came to some part but I couldt reach to the exact solution. Please check the sample file.

Sample File 

I dont understand why

1. under group 335 - zero value must get rank 4 but it gets rank 8 and rank 4 is missing
2. under group 120 - listed as rank 2 and rank 4 but it should be 1 & 2
3. under group 393 - listed as rank 1 and rank 10 ??? should be 1 & 2

what am i doing wrong ?

Thank you for your time & help...

[v-jianboli-msft · Accepted solution]

Hi @umutkoyun ,

Approve with @Jihwan_Kim. Here are several methods may help you:

1. Change the Aggrate of Measure, such as Average, Maximum, Minmum:

2. Change the Data type of Measure 3 to Text:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jihwan_Kim]

Hi,

I am not sure if I understood your dataset correctly, but please check the aggregation type when the Measure3 column was pulled into the visualization. Now, it is SUM, so that is why it is not showing the correct ranking number when one accountnumber showed up two or more than two rows in the table.

If your DAX formula that is used for creating calcualted column [Measure3] is correct, try using different aggregation type when pulling into the visualization.