Top N stacked bar graph does not filter the values based on additional filter

[Anonymous]

here is an example.

I have 3 countries.
Each country has some regions.
Each region has temperatures for each month.

I want to show the stacked graph to show the TOP5 regions with highest temperatures for last 6 months

As we know topN pulls whole data, sorts to find top N and simply shows the values for those categories ( regions) over 6 month period.

Now,I want to apply the filter of countries. I want the TopN to look for the data from only selected countries, apply the Top5 logic only for temperatures for regions from selected countries and replot.

I noticed this does not work as expected above.

Does anyone know how to solve this?

-SuG

[amitchandak]

This one should help

https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/

You have to filter a using rank

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

[Anonymous]

[v-qiuyu-msft]

Hi @Anonymous, 

You can create a measure below: 

Measure = CALCULATE(SUM('Table'[Amount]),FILTER('Table','Table'[Country]=MAX('Table'[Country])&&'Table'[State/Province]=MAX('Table'[State/Province])))

Then set a TopN filter for chart based on this measure: 

Best Regards,
Qiuyun Yu

[v-qiuyu-msft]

Hi @Anonymous, 

Would you please share some sample data then clarify corresponding result? 

Best Regards,
Qiuyun Yu