Forum Discussion
TOP 10 countries using DAX code
Hello Experts,
I want to help me to write the DAX code to show only the TOP 10 Countries based on Revenue.
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] )
7 Replies
Anonymous
Top 10 Countries By Revenues = VAR _top10_countries = TOPN(10, ALLSELECTED('Table'[Country]),[Revenues Measure]) RETURN CALCULATE( [Sales Amount], KEEPFILTERS(_top10_countries) )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?