Forum Discussion

TAP936's avatar
TAP936
Helper I
5 years ago
Solved

Aggregating totals

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?

Need Help

3 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    5 years ago

    TAP936 

    You probably need SUMX.

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

    • TAP936's avatar
      TAP936
      Helper I
      5 years ago

      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?

      ?