Multiple Levels/Drills Rank Measure (Problem)

Hi v-yulgu-msft

First of all thank you for the answer, it is really helpful. It has solved 50% of my problem.

Now, I can drill down in multiples levels getting proper ranking results. The good thing is this method  makes drill down possible even in multiple levels, not only two, opening a wide range of opportunities by using IF and NOT functions.

But still the second problem I mentioned is present.

1. When I click over a visual, narrowing down the list on table, all families/countries are shown, even when they don't have any result to show up.
2. Same thing when I drill down in one family, Table is not showing me only those results with values, but all countries, regardless they have sales or not.
3. I've attached two pictures for further explanation.

How can amend the formula to only show values with figures?

Using VALUES instead of ALL in RANKX function doesn't work.... Perhaps a combination of FILTER+VALUES like EnterpriseDNA (Sam Mckay did here) but my DAX skills are still limited :-(

https://www.youtube.com/watch?v=IyrNH7aD_qk&t=408s

Awaiting for your feedback :-)