Forum Discussion
Resolver ICumulative total measure
I think I might have figured out the issue with the following calculation...
Developed Exp Disp Cnt = CALCULATE([Exp Disp Count],FILTER(GROUPBY(ALLSELECTED(Invoice),'Dispatch Date'[FULL_DATE],Invoice[Days Developed]),Invoice[Days Developed]<=MAX(Invoice[Days Developed])))
However...for some reason the 'total' is not adding up correctly.
I have 2 values...29116 + 25061 that should equal 54177....but the total is 53440?? The measure I'm using to calculate is
calculate(Distinctcount(Dispatch ID),grss amnt <> 0) For some reason BI gives the correct number...but totals them incorrectly?
Resolver II think I might have figured out the issue with the following calculation...
Developed Exp Disp Cnt = CALCULATE([Exp Disp Count],FILTER(GROUPBY(ALLSELECTED(Invoice),'Dispatch Date'[FULL_DATE],Invoice[Days Developed]),Invoice[Days Developed]<=MAX(Invoice[Days Developed])))
However...for some reason the 'total' is not adding up correctly.
I have 2 values...29116 + 25061 that should equal 54177....but the total is 53440?? The measure I'm using to calculate is
calculate(Distinctcount(Dispatch ID),grss amnt <> 0) For some reason BI gives the correct number...but totals them incorrectly?
Resolver IK...I figured it out. The data for Dispatch ID was set to 'whole number' rather than 'text'...so it was doing something funky to the calculation. I'll keep this posted just in case it helps someone.