Solved: Re: Aggregating totals

TAP936 · ‎11-20-2020

Hi

Im trying to build a report with a control chart visual

The upper control line is based on the formula ‘T2_HI’ – ‘T2_Target’ = UCL

T2 HI = 14.9

Target = 13.8

UCL = 1.1

When I try to subtract T2_HI from T2_Target in dax (UCL =[T2 HI] - [T2 Target]) I’m getting an aggregation and each line shows as 3.3

How do I stop this happening please?

PaulDBrown · ‎11-20-2020

You probably need SUMX.

Measure =SUMX(Table, [the subtraction measure])

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

TAP936 · ‎11-26-2020

just needed a unique identifier for this to work.

PaulDBrown · ‎11-20-2020

You probably need SUMX.

Measure =SUMX(Table, [the subtraction measure])

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

TAP936 · ‎11-23-2020

Hi,

I'm so glad you said this as that was what i thought i had to do and thought i was getting confused.

I still get the same result?

?

Aggregating totals