How to get absolute values on forecast and actual ?

[Srikantht]

Hi guys,

I have a scenarioa.  I have 2 tables Articles in one table & forecast , actual in another table (total 2 tables). I want to show the data by aricle level. 

I want output is 30 as like above yellow marked . 

I wrote the below measure but I got 80 is the ouput

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

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

Thanks in advance. 

[v-jingzhang · Accepted solution]

Hi @Srikantht 

Break up the measure into two measures. This will make it work. 

ABS = ABS(SUM(Forecasts[Forecast]) - SUM(Actuals[Actual]))


ABS Diff = SUMX(VALUES(Articles[Article]),[ABS])

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Srikantht]

Hi @

v-jingzhang

PREVIEW

Thank you for giving your solution. 

The below query worked 

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

and your solution also works. 

once again thank you I really appriciate you.

IPREVIEW

[Srikantht]

Any one Help me to write a measure.