Aggregation Issue

[jamesgregory589]

location and product code	location	product	Sales	forecast
abc- 1234	abc	1234	75	85
def-5678	def	5678	82	80
ghi-9101	ghi	9101	77	78

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

[speedramps]

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.