cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TableuOldPBINew Frequent Visitor
Frequent Visitor

Absolute Value Forecast Accuracy Rollup/down

Hi.  I am reaching out for help on how to properly calculate the absolute value ultimately at the item level but I would like the metric to continue to roll up/down through different categories.   In the table below the Act vs Fcst (ABS) values are at the month level which is the absolute value of the Act vs Fcst column.  This holds true at the total level where I would like to have the total be the sum of the months or level above.  (Act Total).  Any help would be greatly appreciated.

 

 

Month Act vs Fcst (ABS)  Act vs Fcst 
January                  716,970            (716,970)
February                  106,831            (106,831)
March                  337,249            (337,249)
April                  234,246            (234,246)
May                  214,143            (214,246)
June                  439,131            (439,131)
July                    70,752                 70,752
PBI Total              1,977,818        (1,977,818)
Act Total              2,119,322 

 

1 ACCEPTED SOLUTION

Accepted Solutions
OwenAuger Super Contributor
Super Contributor

Re: Absolute Value Forecast Accuracy Rollup/down

Hi @TableuOldPBINew 

You can do this by writing a measure that sums Act vs Fcst (ABS) at the month level.

 

Below is an example of this sort of measure:

 

(From your description, I'm assuming Act vs Fcst (ABS) is a column. If it's a measure, replace the code in red with the measure name.)

 

Act vs Fcst (ABS) summed by month =
SUMX ( 
    VALUES ( YourTable[Month] ),
    CALCULATE ( SUM ( YourTable[Act vs Fcst (ABS)] ) )
)

Please try that out and post back if needed.

 

Regards,

Owen



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

3 REPLIES 3
OwenAuger Super Contributor
Super Contributor

Re: Absolute Value Forecast Accuracy Rollup/down

Hi @TableuOldPBINew 

You can do this by writing a measure that sums Act vs Fcst (ABS) at the month level.

 

Below is an example of this sort of measure:

 

(From your description, I'm assuming Act vs Fcst (ABS) is a column. If it's a measure, replace the code in red with the measure name.)

 

Act vs Fcst (ABS) summed by month =
SUMX ( 
    VALUES ( YourTable[Month] ),
    CALCULATE ( SUM ( YourTable[Act vs Fcst (ABS)] ) )
)

Please try that out and post back if needed.

 

Regards,

Owen



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

TableuOldPBINew Frequent Visitor
Frequent Visitor

Re: Absolute Value Forecast Accuracy Rollup/down

Thank you for the quick response.  I will give this a try.  Just curious will this work when a user uses the drill through option?

OwenAuger Super Contributor
Super Contributor

Re: Absolute Value Forecast Accuracy Rollup/down

Realised I hadn't responded to your follow-up question.

It should work with drill-through if you are displaying the same measure, but post back if you have a specific scenario where results are not as expected.

Regards,

Owen



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 140 members 1,629 guests
Please welcome our newest community members: