cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Srikantht
Helper I
Helper I

How to get absolute values on forecast and actual ?

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. 

Srikantht_0-1659042824643.png

 

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. 

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

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])

vjingzhang_0-1659406097777.png

 

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

View solution in original post

3 REPLIES 3
v-jingzhang
Community Support
Community Support

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])

vjingzhang_0-1659406097777.png

 

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

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
Helper I
Helper I

Any one Help me to write a measure. 

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.