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

Should have stated Top 3. Sorry

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

I got closer by using Body Grouping as Filter and using Top 3 by Total Count.  Now I need a measure to use as a filter to show only the the Top 3 Body Grouping.  

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

     

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

      I am still stuck on this on trying trying not to show columns of Cause that are not included in the Top 3 per Body Grouping.  In this case, I should not see Animal, Burn, Scald, , Exposure, Strike, Step on and Struckby

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi bdehning ,

        After my testing, it is unlikely that you want to act on the measure in the filter to achieve your needs, I would suggest the following approach:
        Create these measures:

        Count_Cause = 
COUNT('Table'[Cause Grouping])
        _RANK = 
RANKX(ALLEXCEPT('Table', 'Table'[Body Grouping]), [Count_Cause], , DESC, Skip)
        Output = 
IF( 
    [_RANK] <= 3,
    [Count_Cause],
    BLANK()
)

        Then put the measure Output into the Value of the Matrix:


        Best Regards,
        Dino Tao
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.