Forum Discussion
TOPN
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 res...
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
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