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!!
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
)