Forum Discussion
Solved
FILTER ignore Measure
Hi I have a dynamic week table lookup: Start_week == 1 2 3 4 <--- This is current week I have a transaction table (weekly_files) with Week as transaction date from previous week Start_...
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
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
Thanks AlB it works like a charm. Can you please explain why I need to put my measure in a variable? Sorry, I am new in Power Bi
