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

Count_Cause is not providing accurate numbers either for each Body Grouping?

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

I started to break this down so you can help.  I did create 

Total Cause Count = COUNTROWS(RELATEDTABLE(LossRun))
So now I see table with Counts for each of Rows of Body Part and Cause Grouping.  

I then tried to use 
_RANK =
RANKX(ALLEXCEPT('BodyPart', 'BodyPart'[Body Grouping]), [Total Cause Count], , DESC, Skip), but all _RANK rows show a 1.  

What do I need to correct in _RANK to make it work. 
  • 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)