Forum Discussion
Remove Blanks in matrix table
I have this Matrix Table. Here is my Values Measure Top3CauseCount = VAR CurrentRank = [RankCauseGrouping] VAR CountValue = [Count of Total Gross Incurred +0] RETURN IF( ...
There are 4 rows in your table including the total row. Every row has at least 1 valid number to display. What result do you expect?
I may need to leave as a vertical table, since Top causes are not the same for each year. I was hoping to show the Top 3 Causes by Count for each year. Totals are strange as they muxt be picking up totals of causes outside the Top 3?