Forum Discussion
Using COUNTIF to get top 5 rows for multiple criteris
Hi, I have a table where I need to get count based on 3 columns: Appointment ID, Path, Region. I need to get the appointment count for each path by region first and then show top 5 path count for each region in tabular form in the dashboard. Can you please help me with the DAX for this. I have tried using COUNTIF but getting errors.
5 Replies
this is a sampe of output I want, The columns are region, reasons, appointments
Hi, Souj
Thanks for Ritaf1983‘s reply. Thanks for sharing your desired output, but to solve this problem you need your raw data without sensitive information, it seems that you don't see the columns ‘Appointment ID, Path, Region’ in the output you gave; besides, it would be better if you can give the logic to implement it. It would be better if you can give us the logic to implement it.Here are some notes:
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...Best Regards,
Yang
Community Support Team
cel I would create a hidden table with the counts for all regions using COUNTifs and then create the uploaded table. Not sure how it worls in POWer BI. I tried using TOPN but th values are wrong
In excel**
