topic Re: TOP 10 countries using DAX code in DAX Commands and Tips

TOP 10 countries using DAX code

Anonymous — Sun, 22 May 2022 07:47:32 GMT

Hello Experts,
I want to help me to write the DAX code to show only the TOP 10 Countries based on Revenue.

Re: TOP 10 countries using DAX code

SpartaBI — Sun, 22 May 2022 08:20:09 GMT

Anonymous

Top 10 Countries By Revenues = VAR _top10_countries = TOPN(10, ALLSELECTED('Table'[Country]),[Revenues Measure]) RETURN CALCULATE( [Sales Amount], KEEPFILTERS(_top10_countries) )

Showcase Report – Contoso By SpartaBI

Re: TOP 10 countries using DAX code

Anonymous — Sun, 22 May 2022 11:04:53 GMT

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.

Re: TOP 10 countries using DAX code

SpartaBI — Sun, 22 May 2022 11:07:52 GMT

Anonymous what is the column you use in the matrix for country, and what ia the base measure?

Re: TOP 10 countries using DAX code

Anonymous — Sun, 22 May 2022 11:13:35 GMT

its same, I know you sae different name in code and visual, but its same the coulm and measure.

SpartaBI

Re: TOP 10 countries using DAX code

SpartaBI — Sun, 22 May 2022 11:18:39 GMT

Anonymous it should work :))

What is [Att_Value1]? Is that a column or a measure?

Re: TOP 10 countries using DAX code

Anonymous — Sun, 22 May 2022 11:29:05 GMT

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).

Re: TOP 10 countries using DAX code

SpartaBI — Sun, 22 May 2022 11:35:01 GMT

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] )

Showcase Report – Contoso By SpartaBI