Forum Discussion
kdurbin
9 years agoRegular Visitor
Incorrect Measure Results
I have three measures that I created that are very simple. Two of the measures are Calculates off a Debit/Credit field. The third measure is the simple addition of the first two measures. When...
AlexChen
9 years agoMicrosoft Employee
Hi,
I did a test using your measures and it works properly.
This is sample table:
Create measures “Credit_Totals”, “Debit_Totals”, “Balance” with your code.
This is the result:
You can see that all 3 Balance is correct.
I think your dataset should be much complexed than this.
So I hope you can give a sample dataset and tell us which data is wrong.
Best Regards
Alex
kdurbin
9 years agoRegular Visitor
I got it fixed. The Balance measure was some sort of strange type of measure that had a different icon, so I deleted it and rebuilt it and it works fine. Still can't explain what it was doing, but the data was fine all along. Not sure why the first measure worked part of the time.