Forum Discussion
FILTER ignore Measure
Request W0 = VAR startW_ = [Start Week: 0] RETURN CALCULATE ( [Quantity - Total], FILTER ( dynamic_calendar_lookup, dynamic_calendar_lookup[start_week] = startW_ ) )Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Community ChampionTo avoid context transition interacting with your measure. Note that when you invoke the measure from within FILTER(), there exists a row context that will trigger context transition, that in turn will apply a filter context to your measure when being executed. By invoking the measure at the beginning, outside FILTER() and without a row context present, you avoid that context transition; the measure will yield the same result as when invoked in a visual card, which is what you were looking for. Then, you use that result (immutable after being stored in a variable) in the FILTER () operation.
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers