I have the following two measures:
Measure 1.1 =
DATESINPERIOD(FactAppointment[Date appointment], TODAY(), 6, MONTH))
Measure 1.2 =
MAX(DimCalendar[Date]) <= TODAY(),
SUMX( ALLSELECTED(DimCalendar[Date]), [Measure 1.1] ),
- Measure 1.1 counts the number of appointments in the coming 6 months.
- Measure 1.2 (should) give(s) the result for every date in the date calendar.
The results only show from 6 months in the past however. How can I ensure that the result in measure 1.2 is shown for all dates in the date calendar?