Forum Discussion
eden
Helper I
Helper IReport: How to display TOP 5 Result based on Status ?
Hello
i got a sharepoint list similar to follows
| Workorder | Status | customer | start date |
| One | published | abc | 01/08/2020 |
| two | reviewed | def | 24/09/2020 |
| three | waiting | xyz | 17/09/2020 |
| four | defered | abc | 01/12/2020 |
| five | published | oiu | 01/07/2020 |
| six | in progress | abc | 22/05/2019 |
| seven | in progress | def | 21/07/2019 |
| eight | in progress | kjs | 21/08/2019 |
I am trying to display something like below in Power BI for top 4 customers whose status is not published
The chart is displaying properly but i cannot restrict the top 4 customers as all the customers are diplaying in the report
Regards
12 Replies
- Fowmy
Super User
eden
Try this measure pleaseTop4 = IF( RANKX( ALLSELECTED('Table'[customer ]), CALCULATE( COUNTROWS('Table'), 'Table'[Status] <> "published" ),, DESC) <5, CALCULATE( COUNTROWS('Table'), 'Table'[Status] <> "published" ), BLANK() )________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
edenHow to use the below solutution
Axis : Customer
Value : Top 4
