Please help with rankx and further visualisation

[Avdakushina]

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

[GdBreems · Accepted solution]

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?