This should be easy but not sure how to do it. I have this table where I use Filter Top 5 for Body Grouping by Value Count of Claims.
What measure do I need to be able to see the Top 5 Cause Grouping below and not all of them . In this table it would be Struckby, STF, Caught between, Strain, Cut,Puncture and NC. last two are tied.
@bdehning You'll likely need to incorporate Complex Selector logic into your measure that determines whether to display a value or return BLANK. If you provide sample data as text or a link to a sample file, can be more specific.
The Complex Selector - Microsoft Fabric Community
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
@bdehning You'll likely need to incorporate Complex Selector logic into your measure that determines whether to display a value or return BLANK. If you provide sample data as text or a link to a sample file, can be more specific.
The Complex Selector - Microsoft Fabric Community
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.
Fabric Community Update - February 2025
Find out what's new and trending in the Fabric community.
