Forum Discussion
TOP 10 countries using DAX code
Anonymous it should work :))
What is [Att_Value1]? Is that a column or a measure?
Anonymous no worries 🙂
This is for the scenario where the total is for all (just change it to your names and 10 instead of 3):Top 3 Countries By Sales = VAR _countries = TOPN(3, ALLSELECTED(Customer[Country]),[Sales Amount]) RETURN IF( ISINSCOPE(Customer[Country]), CALCULATE( [Sales Amount], KEEPFILTERS(_countries) ), [Sales Amount] )
SpartaBI
its dose not worked,
see the right visual which I used a filter pane to show the top 10 countries.
In your code dax which is in left visual it dose give the top 10 countries and the numbers are nor correct.
Anonymous what is the column you use in the matrix for country, and what ia the base measure?
its same, I know you sae different name in code and visual, but its same the coulm and measure.
SpartaBIAnonymous it should work :))
What is [Att_Value1]? Is that a column or a measure?
Its worked. So Sorry I had a mistake. I will Accept your solurtions.
I have another Question:
If I want to show top 10 countries and show me the grand total of each country out of all countries ( I dont want to give the grand total of Top 10 countries only).