Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 :
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! 🙂
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 :
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! 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |