How to get the top 3 customers count( Group by Customers)

[kousar99]

Hi Experts,

  How to get the count of the top 3 customers or for example, I have an email id column where I have to show the count of top 3 email Ids, Please help me on this and do the needful.

Thanks,

 Kousar

[rohit_singh · Accepted solution]

Hi @kousar99 ,

One way is to use the in-built TOPN filter 

As you can see, it shows me the top 5 entries by value.

Alternatively, you can also use functions such as RANKX and TOPN to create measures/calculated columns that can help you filter the data. 

Sample calculated column using RANKX is shown below :

Rank =

        RANKX(
                     'TopN',

'TopN'[Position],

,

DESC,

Dense

        )

You can then use this column as a filter on your visual to show you only the desired ranks

Kind regards,

Rohit

Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂