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/...
Fowmy
Super User
Super Usereden
Try this measure please
Top4 =
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 🙂
edenHelper I
Helper IHow to use the below solutution
Axis : Customer
Value : Top 4
- Fowmy
- Fowmy
eden
You may have more than one customer who falls into the top 4. If you have two customers who are ranked top one, they both come.________________________
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 🙂