Matric Visual Total Not Accurate

[smmcqueen]

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 percent without hiding the grand total of headcount (column 2 - 3201)?

[Kedar_Pande · Accepted solution]

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

[SamWiseOwl]

Hi @smmcqueen 

You can create a measure:
Hide Total specific column =
If(
 isFiltered(table[Year]), [Your calculation], Blank())

Is filtered returns TRUE on the row but FALSE on the total.

You could also do HasOneValue(table[Year]) as the total has many years and the row has one.

[_AAndrade]

Hi @smmcqueen,

In your measure put one IF statement like this:

IF(
    ISINSCOPE('YourTable'[YourColumn]), 
    [your measure]
    BLANK() -- Return blank at the total
)