Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Calculate the second and third highest countries by Sales values

Sample data attached    We need to know the top ,top 2nd country and top 3rd country with highest sum of sales. Need to create 3 measures accordingly.         Country Sales Year Month India ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

OK. What have you tried and where are you stuck?

 

Note that your sample data only includes three countries.

Anonymous's avatar
Anonymous
Not applicable
3 years ago
FIRSTNONBLANK(TOPN(2 , VALUES('Table'[Country]),sum('Table'[Sales]) ),1) but it is not giving desired results.
 
I have some date slicers in the page