Forum Discussion
Solved
Multiple Filters in a Cumulative SUM Measure
Hi I have a measure which is calcualting a cumulative SUM CALCULATE(SUM('Turnover & Contribution 20_21 Actuals'[Value]),FILTER(ALL('Turnover & Contribution 20_21 Actuals'),[Month]<=MAX([Mon...
KG1
Modify your Filter Function as below:FILTER( ALL('Turnover & Contribution 20_21 Actuals'), [Month]<=MAX([Month]) && [Budget] = "F1" && [Type] = "Contribution" )________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply š
KG1
Modify your Filter Function as below:
FILTER(
ALL('Turnover & Contribution 20_21 Actuals'),
[Month]<=MAX([Month]) && [Budget] = "F1" && [Type] = "Contribution"
)
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply š
Great - thank you
Worked perfectly
