Sort headers in a Top 3 Matrix visual linked to two different slicers

[maialr]

Good morning all,

I have the following data model based in 3 different tables:

My goal is to build a Top 3 products by store Matrix visual keeping my headers (the products) sorted from largest to smallest total sold units:

In order to do this I choose to create a SUMMARIZECOLUMNS() table in order to figure it out the grand totals regarding each Product (_TotalUnitsSold) and after that create a new calculated column called [OrderByProductTotal] in the 'DimProducts' table related to this in order to have the chance to sort DimProducts[Product] on depends DimProducts[OrderByProductTotal]: in my matrix I used a Top N filter for the DimProducts[Product] field based on my DimProducts[OrderByProductTotal]

By this way, all works fine and also I can even use a slicer to filter the results based on the [Category] in order to change the Top 3 dynamically:

But my question is what happen if I would to use also anothe slicer to filter data regarding my DimStores table like the [Country]? Of course, in this case my dynamic Top 3 doesn't works because the filter propagation:

I guess I should move my [OrderByProductTotal] to the 'FactSales' table due to the filter propagation but I couldn't find a way to sort the DimFactSales[Product] field on depends this field properly or may I change the way I try to sort my matrix Top 3 products (figure it out a different measure for each of my Top 3 products?) or even my data model.

Any suggestions are welcome: I attach the .pbix file with the example.
Sample - Top 3 Matrix Sort based on Two Slicers.pbix 

Thank you in advance.

[v-lionel-msft]

Hi @maialr ,

I can't download your .pbix file, please use Onedrive for business or Sharepoint online to share your .pbix files.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[maialr]

Hello,

Please could you check again the link to download the sample file? Now I hope it works.

Regards