Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Specifying multiple filter conditions in CALCULATE

SQLBI
120K subscribers
103K views 4 years ago
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. Article and download: https://sql.bi/705207?aff=yt How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-defin... ...more
...more
Specifying multiple filter conditions in CALCULATE
1.1KLikes
103,166Views
2021Mar 30
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. Article and download: https://sql.bi/705207?aff=yt How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-defin...

Follow along using the transcript.

SQLBI

120K subscribers