Forum Discussion

ToreT's avatar
ToreT
New Member
1 year ago

Calculation of Totals in matrix visuals

Hello!   I have a problem with calculating totals in matrix visuals and did not find this anywhere else. I have 2 measures that contain data per incident year and development month. By nature, this...
BITomS's avatar
BITomS
Icon for Solution Supplier rankSolution Supplier
1 year ago

Hi ToreT 

 

I think you need to aggregate only where the flag = true. This may help:

 

Diff at last period (Total Fix) :=
SUMX(
FILTER(
ADDCOLUMNS(
'YourTable',
"Flag", [YourFlagMeasure],
"Diff", [YourDiffMeasure]
),
[Flag] = 1
),
[Diff]
)