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 ...
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?
Yes, there are several lines which make up that particular row. If it helps, my data is inventory data so it goes down to the SKU, manufacturing site & current branch.
Possibly but this seems like it should be pretty straight forward. What version of Power BI Desktop are you using?
Are the detail lines from the same EEORE table or from a related table? I think we are getting close to the issue.
Everything is pulling from the same table (which is the original data load).
I'm using the latest version that was released Nov 7th.