Re: Table Sum is incorrect.

ajohn1 · ‎10-16-2018

if I were to take out my first 'if' statement "(if(value1-value2 <= 0, 0,)" the value comes out to be -92. But I'm replacing its value with 0. So why is calculating with the -92.

v-piga-msft · ‎10-17-2018

Hi @ajohn1,

If it is conveninent, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

Best Regards,
Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ajohn1 · ‎10-17-2018

We found a work around, by appending a duplicate of our time and some other magic. To much to explain at the moment.

v-piga-msft · ‎10-18-2018

Hi @ajohn1,

If you solved your problem, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ajohn1 · ‎10-18-2018

I really appreciate replys from the community but neither of them worked for me. I would hate for somone to think the solution is in this thread. To make myself clear, we didnt get the table to add up the right way, but we formatted it to where it would be easy for our customers to understand.

Please close this thread if you can.

dedelman_clng · ‎10-16-2018

PowerBI tables/matrixes don't sum up the same way that Excel does. Instead it recalculates the measure in the current context, which is ignoring the DLIN, DSUB, etc context. It is calculating in the "Louisiana-Customer View" context.