Forum Discussion
Problem with DAX formula
I have created a a measure with a DAX formula that estimates the remaining mandays of a project based on the completion percentage. My DAX formula is the following: "Estimated Remaining MD = ...
So, the problem is your SUM for Completion%. When you are looking at all of the data and grouping by ProjectDpt, for example, if you have 2 projects that are both 0.8 complete, that SUM is going to give you 1.6. 1 - 1.6 = -0.6 and hence the negative numbers.
Actually no, now that I took another look at my data I get wrong numbers even when in my data all competion percetages are different.