Cumalitive Totals witt Slicers

DAX DAX Calculations
1

Hi

I have a cumalitive total calculation - see below, which works fine on my report page that has a Date Slicer using Date Between (see pic). But on my report page that has two seperate Year and Month slicers the Cumalitive Total graph re calculates and is adding the cumalitive totals for all dates in all years (see pic)

I thought i could try using AllExcept in my calculation after watching one of Sams tutorials on that subject but that also did not work. I also checked my date table but can not see anything obvious to me that is wrong.

Any ideas?

Calculation:
Total Injuries Cumalitive =
CALCULATE([Total Injuries],
FILTER(ALLSELECTED(‘Dates’[Date]),
‘Dates’[Date]<=MAX(‘Dates’[Date])))

Pic where calculation is displaying correct results
Capture

Pic where calculation is not applying the year filter slicer

Example%202

2

Hi,

Instead of ALLSELECTED(‘Dates’[Date]) try ALLSELECTED(‘Dates’) to reference the whole date table.

Hopefully this will help.

DiBest

3

Thank you @DiBest it worked :smile: so simple but I would not have figured it out so quickly.

Thanks for your help :slight_smile: