Forum Discussion
Solved
Matric Visual Total Not Accurate
As you can see in the below visual, my matrix displays a total percent (thrid column at the bottom - 43.90%) that does not align with the percents in each row. Is there a way to hide the total percen...
Create a new measure that checks if the current row is a total and returns a blank value:
Display Percentage =
IF(
ISINSCOPE(YourTable[Year]),
[YourPercentageMeasure],
BLANK()
)Use this new measure in your Matrix instead of the original percentage measure.
If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
Create a new measure that checks if the current row is a total and returns a blank value:
Display Percentage =
IF(
ISINSCOPE(YourTable[Year]),
[YourPercentageMeasure],
BLANK()
)
Use this new measure in your Matrix instead of the original percentage measure.
If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn