Power BI Exchange

Hi Guys,

I have a scenario. I have a table & I want to show the data by article level. Here I am getting the difference is 10 but I want the output is 30 on total. 

 I wrote the below measure but I got 80 (I think 8 articles*10) is the output

=SUMX(VALUES(Article[Article]) ,CALCULATE(ABS(sum(Forecast)-sum(Actual))).

any one help me ? How do i write a measure to get the output is 30 ?

Thanks in advance. 

Abs Diff =SUMX (    VALUES ( Article[Article] ),    CALCULATE ( ABS ( SUM ( Article[Actual] ) - SUM ( Article[Forecast] ) ) ))​

Hi Guys,

I have a scenario. I have a table & I want to show the data by article level. Here I am getting the difference is 10 but I want the output is 30 on total. 

 I wrote the below measure but I got 80 (I think 8 articles*10) is the output

=SUMX(VALUES(Article[Article]) ,CALCULATE(ABS(sum(Forecast)-sum(Actual))).

any one help me ? How do i write a measure to get the output is 30 ?

Thanks in advance.