Attached are two files. One is the source data which includes the issue via pivot table (just incase this might help) and the other is the PBIX file showing the dax and the visuals / issue.
Per the PBIX file I am trying to do the following:
- Per week calculate the average price for each customer
- Less the average price per week for all customers
- and Multiply the diff by the quantity per customer (If no quantity it should be zero)
In Visual 1 each week appears to be correctly calculated but the sum of these do not equal the Total. This is a problem for me and causing me a massive headache.
E.g for customer B = -908.21-593.03-1120.09+24.55+500.63= -2096.15 not -2390.96 per the visual
Hopefully this is enough for everyone to go on and I am just making a stupid mistake. I am being chased on this so any feedback is massively appreciated. Thanks Guys