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.
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...
Watch video Specifying multiple filter conditions in CALCULATE online without registration, duration hours minute second in high quality. This video was added by user SQLBI 30 March 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 97,453 once and liked it 1.1 thousand people.