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.
SpartaBI
Community Champion
Community ChampionAnonymous
Top 10 Countries By Revenues =
VAR _top10_countries = TOPN(10, ALLSELECTED('Table'[Country]),[Revenues Measure])
RETURN
CALCULATE(
[Sales Amount],
KEEPFILTERS(_top10_countries)
)
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
Showcase Report – Contoso By SpartaBI
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
SpartaBI Logo
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.