Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

TOPN Function

Hi,    Can you please help me with something?   I have a table that includes the following columns: 1) Tickets ID  2) Created Time  3) Account   I need to calculate the top 10 customers who ...
Need Help
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Create two measures like and check

    CntAccounts = count('All Tickets'[Account])

     

    Top 10 City Rank = CALCULATE([CntAccounts],TOPN(10,all('All Tickets'[Account]),[CntAccounts],DESC),VALUES('All Tickets'[Account]))

     

    refer to my video : https://www.youtube.com/watch?v=QIVEFp-QiOk

Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak  Thank you so much. This worked like a charm. I will try it on my other visuals too to see if it works on all scenarios. The video is very good too!