Forum Discussion
bdehning
Post Prodigy
Post ProdigyShowing 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. ...
bdehningPost Prodigy
Post ProdigyI now am using my own Count which I laready had instaed of Count_Cause and I get correct numbers for each Row for Body Grouping and Cause Grouping.
I switched out _RANK =
RANKX(ALLEXCEPT('BodyPart', 'BodyPart'[Body Grouping]), 'LossRun'[Count of Total Gross Incurred], , DESC, Skip)
I stiill get all 1's under _RANK in my table?
What may be wrong?
I stiill get all 1's under _RANK in my table?
What may be wrong?