Last Date from Slicer

[ryanSROA]

Hi, I'm running into an issue trying to get the last date value of my slicer. Part of my issue I believe is that my Date table is connected to my data table by a different value then what I'm trying to write against. Here is my formula...

MEASURE = CALCULATE(SUM(Charges[dcAmt]), FILTER(Charges, Charges[dPmt] > DATE(2020,3,31)))

This works with the date placed in, but I need it to be dynamic with the date slicer. When I try switching the 3/31/2020 to this it stops working:

CALCULATE(MAX('Calendar'[Date]), ALLSELECTED('Calendar'[Date]))

The 'Calendar'[Date] connects to Charges via Charges[dCharge] instead of [dPmt], so I"m wondering if that's why. I've tried a bunch of different things but can't get this to work.

[Greg_Deckler · Accepted solution]

In theory it should just be:

MEASURE = CALCULATE(SUM(Charges[dcAmt]), FILTER(Charges, Charges[dPmt] > MAX('Calendar'[Date])))

[ryanSROA]

Thanks Greg! That does work. My issue was I was using All(Calendar[Date]) in the formula because of the way my data is setup. I replaced that with datesbetween and it worked.