Specifying multiple filter conditions in CALCULATE

The filter arguments in CALCULATE can reference multiple columns from the same table in a single predicate: This is possible since March 2021 in Power BI, before that it was possible to filter a single column reference.

[MahmoudSamiroda]

This channel should has more subscribers. Thank you always saving my day.

[abdulrehman]

Marvellous you guys are marevellous in DAX. You make such easy to understand DAX so I watched whole video without skipping a singal second

[mnowako]

It’s a good addition - no doubt about it. But FILTER ( CROSSJOIN ... - you nailed it 👍. I always learn something new from your videos. Thank you!

[excelisfun]

This is a HUGE improvement!!!! Thanks for the great video : )

[williamarthur]

Just what I'd been trying to do, I've used cross join but would never have thought to use to create a single table to filter on. It's great the way you explain what's happening rather than just 'how to do' .

[padwan]

Thank you! I've been trying to countif in dax with multiple criteria for what feels like an age. This really helped.

[maheshdama]

Your DAX videos always inspire me to learn more about DAX

[humzaiftikhar]

I have no words to Thank you for such a great effort.

[sue_bayes]

Thank you, was waiting for this once the new feature was introduced. Really helpful to understand what is happening in the background of the DAX.

[ameyraj]

Informative as always. The concluding audio clip is very good. I love it.

[anilyadav-rtsr]

It is very helpful for me because I'm preparing a dashboard for my team. Thanks 🤜🤛

[MrMalorian]

Oh man, I really needed this 6 months ago

[cptdeadeye]

There's such wonderful content in this channel.

[ukaszk]

Thank you Alberto for this video. So actually in 10:41 the figure corresponding to 'White' is sales of white products of Contoso brand, because KEEPFILTERS makes an intersection of existing filters and the ones in the CALCULATE arguments. Using sort of math's set theory notation, where elements are the table rows:
(red ∪ Contoso) ∩ white = (red ∩ white) ∪ (Contoso ∩ white) = Ø ∪ (Contoso ∩ white) = Contoso ∩ white
And the value for 'Red', below 'White', is the sales of red products regardless of the Brand:
(red ∪ Contoso) ∩ red = (red ∩ red) ∪ (Contoso ∩ red) = red ∪ (Contoso ∩ red) = red // as (Contoso ∩ red) is a subset of red

[gilbertosegoviano]

You are the best🎉, thanks for sharing

[guillaumejean]

Thank you so much ! It solved my problem !

[faelbr]

Thanks for the video, extremely helpful, as usual.

[nithinshankar]

This makes developer work easier🤩 and increase the performance

[noahhadro]

Which is faster and best practice? 1) "Filter( CrossJoin ( All( 'product'[Color]), All ('Date'[Calendar Year]) ), 'product'[Color]) = "Red" || 'Date'[Calendar Year] = "CY 2010"))

OR adding two filters like below? I know the date table is probably relatively small. what about if you were doing this with two bigger DIM tables.

Filter(All( 'product'[Color]), 'product'[Color] = "Red" ), Filter (All ('Date'[Calendar Year]), 'Date'[Calendar Year] = "CY 2010")

This question is in regards to what you show at minute marker 8:30. Thanks for the great content!!!!

[joaquimcosta]

Very nice likes always! Thanks for your time..