Please help with rankx and further visualisation

Avdakushina — Fri, 16 Sep 2022 13:40:52 GMT

Hello everybody!

Just looking for some help with rankx function.

I have a table that contains information about products sold on a disaggregated basis by segment, manufacturer, total units and product name. I need to rank Products based on total units sold. So my formula is

Rank = RANKX (ALLSELECTED('Product'), SalesFact[Total Units])

But further visualisation is incorrect. I need to create a tree diagram showing 3 best selling products by "Abbas" manufacturer in three segments (All season, Moderation and Extreme). So i want to see 9 products in my diagram, 3 in each segment.

But the outcome is the following:

So I only see the first 3 best selling products, not 3 best selling products in each category.

What is wrong here?

Looking forward to your answer

Re: Please help with rankx and further visualisation

GdBreems — Fri, 16 Sep 2022 14:24:26 GMT

Hey, maybe you can fix it as follows:

Rank =

RANKX(

ALLEXCEPT(Table,Table[Manufacturer],Table[Segment]),

[Measure on which rank is based],,DESC

)

This way you get a rank per segment for each manufacturer.

Then in the Visual you can put a filter in the filterpane where Rank < 4.

Edit -> Changed [Measure/Calculation on which rank is based] to [Measure on which rank is based].

RankX only seemed to work when refering to a measure, not when putting the calculation within said measure directly into RankX, anyone knows why?

topic Re: Please help with rankx and further visualisation in DAX Commands and Tips

Please help with rankx and further visualisation

Re: Please help with rankx and further visualisation