Simple Addition Errors in DAX

[cnort21]

On occasion when refreshing data in the tables, I will see huge errors in simple addition formulas such as the below:

=[Max Inventory Value]+[Min Inventory Value]

Once I delete the formula, enter, and repost the formula, it corrects itself. Does anyone know why this would be the case? Is there a better way to post a formula like that to not get this error?

Thanks,
CN

 

[Robert Mika]

Could post sample of your data?
What's your error look like?

 

[cnort21]

Robert, thanks for your reply. I don't actually see an error message. It's that the formula itself is producing an error. I usually don't see this issue in more complex formulas, however simple formulas like the one mentioned above will occasionally produce the error below.



[TABLE="width: 243"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Min Inventory Value[/TD]
[TD]Max Inventory Value[/TD]
[TD]Total Inventory Value[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2[/TD]
[TD] 5[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]0[/TD]
[TD] 1[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]3[/TD]
[TD] 32,467[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]1[/TD]
[TD] 7[/TD]
[/TR]
</tbody>[/TABLE]

 

[Robert Mika]

Third row is giving strange result.
Should not that be 8?

 

[cnort21]

Yes, that is the issue that I am seeing. This usually happens when I have many Calculated Columns in the same sheet. It usually fixes itself when I copy and repaste the exact same formula, but it could lead to errors if I don't catch the issue. I'm wondering if this is something that happens to other people, and if using simple addition formulas work differently than how I would expect in PowerPivot.

 

[Robert Mika]

If we seen the big picture taht woudl help.
You can upload your data to dropbox if you need futher assistance.

 

[cnort21]

Unfortunately, the error does not happen every time, so it's not something that I have ready access too. When it comes up again, I will post the data.

Really, I was hoping there was a problem with using simple addition equations in PowerPivot.

Thank you for your response.

 

[theBardd]

Sounds like your PP is up the swannee, it shouldn't do that. I would uninstall and re-install if I were you.