Forum Discussion

codyraptor's avatar
codyraptor
Icon for Resolver I rankResolver I
9 years ago
Solved

Cumulative 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(Invo...
Need Help
  • codyraptor's avatar
    codyraptor
    9 years ago

    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?

codyraptor's avatar
codyraptor
Icon for Resolver I rankResolver I
9 years ago

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?