Forum Discussion
Resolver ICumulative total measure
I'm trying to create a cumulative total measure. The following is what I have...
Developed Exp Disp Cnt = CALCULATE([Exp Disp Count],FILTER(ALLSELECTED(Invoice),Invoice[Days Developed]<=MAX(Invoice[Days Developed])))
This is what I get just using the Exp Disp Count measure....
This is what I get when using the cumulative measure above...
It is obviously giving me the total by days developed. What I want is for it to cumulate by days developed...but also by date. Another words...201610 should show 14562 for 30days...and 14563 for 60days. Suggestions? Thanks!!
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?
2 Replies
codyraptorI 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?
- codyraptor
K...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.