Forum Discussion

bdehning's avatar
bdehning
Icon for Post Prodigy rankPost Prodigy
2 years ago

Showing Top 3 Counts in Matrix Table

I have this Matrix table that uses Body Grouping for Rows, Cause Grouping for Columns and Values is Total Count.  What do I need to create to show only the Top 3 Causes For the Top 3 Body Grouping.  ...
Need Help
bdehning's avatar
bdehning
Icon for Post Prodigy rankPost Prodigy
2 years ago

I added more data to your example in both columns and it shows Body Grouping and Cause Grouping when count is only one and starts to add more than 3 Rows.     Here is my current table.    It is not just showing TOP 3 Body Grouping now.  

 

bdehning's avatar
bdehning
Icon for Post Prodigy rankPost Prodigy
2 years ago

Here is my Table I have now for the Slicer Selection I have.   

How would your _RANK measure below change with my model? 

_RANK = 
RANKX(ALLEXCEPT('Table', 'Table'[Body Grouping]), [Count_Cause], , DESC, Skip)