Forum Discussion
Summary Error with IF Statement
Hello, I'm having issues with an IF and/or SUMX formula. I essentially need the calculation done at every line level & then aggregated. With my first attempt using IF, the results are correct at ...
Hi aminw0u
Are the lines in your matrix an exact match to the lines in your source data? Or are these aggregated values?
They are aggregated on some level. I have a data set with 34 columns & I only pulled 7 of those into my filter to drill down through before I got to what you see here.
So for SKU Name 87 you have a values of $71 and $88
Are these values based on multiple rows that have been aggretated to this single line?
Here is a cut down model using your exact formula showing it working ok
https://1drv.ms/u/s!AtDlC2rep7a-oB-2n_WxkVzte_RD
So just trying to work out the differences. Are you using calculated measures or calculated columns?
