Count future values regardless of slicer range

[ryan_b_fiting]

Hello Community - 

I have an issue I am facing regarding the measuring of future values.  I have a date slicer on my report page (from a calendar table that is then joined to other tables)

Despite that filter which i needed for many of the metrics, I also have patients that book appointments into the future which I will see the appointments with a future appointment date on them (ie 5/3/2022 6/3/2022 etc).

I need to be able to calculate all appointments that are within the slicer range, but then also include ALL appointments that have a future date associated with them.  So my calculation currently is:

Booked Appointments = CALCULATE(
    '1-Measures'[Appointments],
       ALL(Date_Table) )

but this gives me all appointments that are prior to my date slicer range as well.  What filter context do I need to put on my measure to get it to include all Appointments within the sliced range AND BEYOND?

Thank You Community

Ryan

[jdbuchanan71 · Accepted solution]

@ryan_b_fiting 

Try something like this.

Booked Appointments =
VAR _MinDate =
    MIN ( Date_Table[Date] )
RETURN
    CALCULATE (
        '1-Measures'[Appointments],
        ALL ( Date_Table ),
        Date_Table[Date] >= _MinDate
    )

[ryan_b_fiting]

Thanks @jdbuchanan71 this worked perfect.

[Greg_Deckler]

@ryan_b_fiting Use MAX to get your max date range. Then include > that date in your CALCULATE as a filter statement along with your ALL.