Getting the bottom 13th Value

[Greg]

Hi @jonatong. You can use composite ranking … first by Product, then by Product Sub Type. Here’s a recent forum thread with more details.

Rank YTD Total over 2 added Measures

@chris.turnbull, One other thing you may find helpful is my Data Challenge #4 entry. On the report page screenshot below, I created a composite ranking index approach composed of five other rankings. Explanation in the thread below, along with my PBIX where you can go through all the relevant measures, etc. [image] I hope this is helpful to you. Brian

Hope this helps.
Greg