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)
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)