Custom Total for Matrix Visual

[gksdude9192]

Is there a way to show the Total 5 instead of 7 ?

[gksdude9192 · Accepted solution]

By using Hasonevalue i got the solution.

Measure = 
var _all = SUM(Table[Value])
var _filtered = CALCULATE(SUM(Table[Value]), NOT Table[Category] IN {"F","G"})

RETURN 
            IF(HASONEVALUE(Table[Category]),_all,_filtered)

[SamWiseOwl]

Hi @gksdude9192 

You can create a measure, this can show a different value for the row than total.

For example:
Swap Total =
If(
IsFiltered(table[Category])

,Sum(table[Value])

,5
)

That will show the sum of VALUE on the rows and the number 5 on the total.