Need Cumulative Measure

[cmcgo3]

I am trying to create a new measure that will calculate a cumulative total in either a table or matrix as well as give correct total in a card.  In the attached pbix file the cumulative total for this small dataset should be 3. My verification counter measure has variables.  I understand that the below measure works under normal circumstances but its not calculating accurately.  Any help is appreciated!

Cumulative =

CALCULATE([Verification counter],

     FILTER(ALL('Table1'[Day of Week ]),

        'Table1'[Day of Week ] <= MAX('Table1'[Day of Week ])

     )

)

Cumulative.pbix 

[RossEdwards · Accepted solution]

Give this a try:

Cumulative = var endDate = MAX('Table1'[Day of Week ])
RETURN
CALCULATE(
	[Verification counter],
	ALL('Table1'[Day of Week ]),
	'Table1'[Day of Week ] <= endDate
)

[Anonymous]

Hi, @cmcgo3 

Thanks for @RossEdwards  reply. You can refer to the following dax to solve the problem.

Cumulative = 
VAR _table =
    SUMMARIZE (
        'Table1',
        'Table1'[Day of Week ],
        "Verification counter", [Verification counter]
    )
RETURN
    SUMX ( _table, [Verification counter] )


CumulativeVerificationCounter = 
CALCULATE (
    [Cumulative],
    FILTER ( ALL ( Table1 ), Table1[Day of Week ] <= MAX ( Table1[Day of Week ] ) )
)

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[cmcgo3 · Accepted solution]

THANK YOU BOTH!  This works perfectly!!!  What a great resource this platform is!!

[RossEdwards · Accepted solution]

Give this a try:

Cumulative = var endDate = MAX('Table1'[Day of Week ])
RETURN
CALCULATE(
	[Verification counter],
	ALL('Table1'[Day of Week ]),
	'Table1'[Day of Week ] <= endDate
)