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
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]))
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |