Forum Discussion
Solved
Need Cumulative Measure
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 thi...
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 )THANK YOU BOTH! This works perfectly!!! What a great resource this platform is!!
Hi, cmcgo3
Thanks for Anonymous 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
THANK YOU BOTH! This works perfectly!!! What a great resource this platform is!!