TOPN

[Anonymous]

Hi, Im trying to get the top 25 customers But is shows the result of the total sales, not only top 25. this is how i wrote: Top 25 = VAR top = TOPN(25,ALL(TABELA_SUMMARISE[COSTUMER]), [Sales]) VAR result = CALCULATE([Sales],top) return result

[amitchandak · Accepted solution]

@Anonymous ,

Try like

 VAR top = TOPN(25,ALL(TABELA_SUMMARISE[COSTUMER]), [Sales]) VAR result =CALCULATE([Sales],top , values(TABELA_SUMMARISE[COSTUMER])  )

TOPN: https://www.youtube.com/watch?v=QIVEFp-QiOk&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=42