Forum Discussion

Guille2711410's avatar
Guille2711410
Icon for Helper I rankHelper I
6 years ago

Top 10

Hello I would like to get the top 10 of my collected commissions, but I also want to prevent the number 1 from appearing, since it is not identified. The formula I use is: M_Top10 =       VAR ComP...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Guille2711410 , Try like

Top 10 City Rank = CALCULATE([Sales],TOPN(10,all(Geography[City]),[Sales],DESC),VALUES(Geography[City Id]))

Guille2711410's avatar
Guille2711410
Icon for Helper I rankHelper I
6 years ago
Excellent!!! All ok Thank you very much amitchandak and also for my previous query Guille