Forum Discussion
Filtered visuals show all months when using +0
Hi rachels920 - Ensure the relationship between Date and Previous Date is correct and active only when needed viaUSERRELATIONSHIP. Filtered Month & Year: Verify that correctly reflects the month and year you're filtering on. If this is not working as expected, you might want to inspect how this measure is defined.
MyResult L13M =
VAR SelectedMonth = [Filtered Month & Year]
VAR PreviousDates =
DATESINPERIOD(
'Previous Date'[Date],
SelectedMonth,
-13,
MONTH
)
VAR Result =
CALCULATE(
[MyResult], // Use the original MyResult calculation
REMOVEFILTERS(_Dates), // Remove filters from the main date table
KEEPFILTERS(PreviousDates), // Apply 13-month date filter
USERELATIONSHIP(_Dates[Date], 'Previous Date'[Date])
)
-- Include zero for missing values but respect the date filter
RETURN IF(NOT(ISBLANK(Result)), Result, 0)
Hope it helps.