Issue with Rankx TopN in Matrix

[Yatz86]

Hi all,

Need your assistance.
I am trying to figure out how to filter top 10 materials on each occasion in a matrix visualization.

Managed to create the ranking comparison, using below example as reference.

https://www.youtube.com/watch?v=ICfhw-J6_1o&t=259s

The issue I face is that the Top 5/Top 10 slicer does not display the top 5/10 in the matrix as it should as I include more criteria into the Rows in the matrix visualization.

Need your advice on the possible solution on this.

Below is the link to the source data and PBIx.
https://wetransfer.com/downloads/43a0427d969165c04dc8bf42a430245120190830080142/8da4f2

Thanks in advance!

Regards
Hidayat

[JarrettM]

The formula the way you have it only sorts by Material, when you add in the Occasion that is when there is an issue. I will work on a solution, but only have to adjust the RANKX Measure in order to do so. Here is picture of what you have currently setup with your formula.

Thanks

[JarrettM]

This works properly if you take out the material name column. Look at picture attached. If you want material name column to be included, will need to add that to the measure. Let me know what you think.

I have also attached a more recent video Sam did with RANKX that may help your situation.

Advanced RANKX - How To Understand This Function More Deeply

Thanks

[Yatz86]

@JarrettM, would prefer to have the material name included.

Thanks for the video recommendation!

Would this mean that I would need to create a unique value if there were more criteria added into row?

for example. for now add material name, next will want to add in color name.

Regards
Hidayat

[JarrettM]

Yes, you are thinking correctly.

Cheers