Forum Discussion
Solved
Custom Total for Matrix Visual
Is there a way to show the Total 5 instead of 7 ?
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)
2 Replies
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.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)
