topic ranking one column grouped by another column in DAX Commands and Tips

ranking one column grouped by another column

Anonymous — Tue, 09 Aug 2022 08:35:54 GMT

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

under group 335 - zero value must get rank 4 but it gets rank 8 and rank 4 is missing
under group 120 - listed as rank 2 and rank 4 but it should be 1 & 2
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...

Re: ranking one column grouped by another column

Jihwan_Kim — Tue, 09 Aug 2022 08:50:11 GMT

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.

Re: ranking one column grouped by another column

v-jianboli-msft — Tue, 23 Aug 2022 09:38:58 GMT

Hi Anonymous ,

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.