Forum Discussion
Week on Week change by Calculation Group
I am using this code to determine the week-on-week change in the calculation group. The requirement is similar to any other week-on-week change visualization function only I want to compare last wee...
Shahid12523
Community Champion
Community ChampionYour PreviousWeek is blank because filter conditions weren’t applied correctly.
Fix with FILTER(ALL()) instead of direct column conditions:
VAR _PreviousWeek =
CALCULATE (
SELECTEDMEASURE(),
FILTER (
ALL ( Clubbed_Data_Raw ),
Clubbed_Data_Raw[Week] = MAX(Clubbed_Data_Raw[Week]) - 1 &&
Clubbed_Data_Raw[Year] = MAX(Clubbed_Data_Raw[Year])
)
)