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'[Exception...
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.

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