Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Cumulative total is not working

I am using the above Query still I can see the count of that particular month in the bar graph, but it is not cumulating current month  to next month.  Cumul =CALCULATE ( SUM(('DimApproved'[ExceptionCount])), FILTER (ALL('DimTime'[Date]),'DimTime'[Date]<= MAX ( 'DimTime'[Date] )))

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    @v-saibol You may try:

    =
VAR __Max = MAX ( 'DimTime'[Date] )
RETURN
CALCULATE ( SUM(('DimApproved'[ExceptionCount])), FILTER (ALL('DimTime'[Date]),'DimTime'[Date]<= __Max))

    Otherwise, see if the built-in Total fast running measure helps.

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    @v-saibol You may try:

    =
VAR __Max = MAX ( 'DimTime'[Date] )
RETURN
CALCULATE ( SUM(('DimApproved'[ExceptionCount])), FILTER (ALL('DimTime'[Date]),'DimTime'[Date]<= __Max))

    Otherwise, see if the built-in Total fast running measure helps.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Greg, Thanks for prompt response, but still my issue is not resolved Cuml = VAR KMax = MAX ( 'DimTime'[Date] ) RETURN CALCULATE ( (SUMX( VALUES( 'ActiveExceptions'[Exception ID] ) , ([TE]))), FILTER (ALL('DimTime'[Date]),'DimTime'[Date]<= KMax)) As TE is measure, Distinctcount of ExcpIds. PLease help. Still it is not summing up Cumulative. Thanks Sai