Forum Discussion
Summary Error with IF Statement
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?
Thanks. I'm using measures. The Expired PQ & Gross Scrap are measures as well. I had tried calculated columns earlier & got circular references, so that didn't seem like the way to go.
Is it possible that this is just a bug? I would have expected my formula to work the same as what you have in your file, and I've had several instances of formulas not working when they should have (including while at a DIAD training with Microsoft instructors looking over my shoulder wondering why it wasn't working).
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?