Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
jamesgregory589
New Member

Aggregation Issue

location and product codelocationproductSales forecast
abc- 1234abc12347585
def-5678def56788280
ghi-9101ghi91017778

 

I am trying to get a forecast accuracy by shipping location and product. Currently we have been trying to make a measure to take the absolute variance of the sales and the forecast and then using the equation below to calculate the forecast accuracy. It seems to punch out the right numbers in the table view, but when I go to the report view I am having a bunch of aggregation issues. How do I manage this to do it at the levels I want it ?

 

IF([ Abs Variance]>[sales],0,

    IF([Abs Variance] = 0,1, 1- [ Abs Variance]/[Sales]))

 

1 REPLY 1
speedramps
Super User
Super User

You have not provided sufficient information.
Eg what are the  [ABS Variance] and [Sales]  measures.

 

Please provide the input date.

The expected output reports.

And the dax measures

 

However, it sounds like you might not be using SUMX to compute aggregations

 

please click thumbs up and accept as solution.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.