Forum Discussion
Question of Filter the Measure
Hello, Below is my current measure that displays the cumulative CheckFeatures by WeekStartingDate. It works correctly when no additional filters are applied: CumulativeCheckFeatures = VAR CurrentW...
Thanks for your help. Unfortunately chage from ALL(Features) to ALLSELECTED(Features) does not help. Any other suggestions ?
Khushidesai0109
Skilled Sharer
Skilled SharerHiiii yzhouMC
Please try this
CumulativeCheckFeatures =
VAR CurrentWeekEndSK =
CALCULATE(
MAX(DatesTable[DateSK]),
DatesTable[WeekStartingDate] = MAX(DatesTable[WeekStartingDate])
)
RETURN
CALCULATE(
SUM(Features[CheckFeatures]),
FILTER(
ALLSELECTED(DatesTable),
DatesTable[DateSK] <= CurrentWeekEndSK
),
FILTER(
ALLSELECTED(Features),
Features[CreatedDateSK] <= CurrentWeekEndSK
)
)
If this helps, I would appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!