TOP 10 countries using DAX code

[Anonymous]

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

[SpartaBI · Accepted solution]

@Anonymous it should work :))

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

[SpartaBI]

@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

      

[Anonymous]

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

[SpartaBI]

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

[Anonymous]

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

@SpartaBI 

[SpartaBI · Accepted solution]

@Anonymous it should work :))

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

[Anonymous]

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

[SpartaBI · Accepted solution]

@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