Use the IN operator in CALCULATE filters.
How to learn DAX: sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
CALCULATE function: dax.guide/calculate/?aff=yt
- CALCULATE in DAX #08: Add filters using IN ( Download)
- How to Use Filter Function in DAX [Power BI] ( Download)
- DAX CALCULATE Function Made Easy to Understand (just one word) ( Download)
- CALCULATE in DAX #07: Add multicolumn filters ( Download)
- Power BI DAX || SUMX || Multiple filters || Creating a measure ( Download)
- Elements of DAX 06-08: Override Filtering with CALCULATE() (B) ( Download)
- CALCULATE in DAX #04: Add table filter (and difference with column filters) ( Download)
- Understanding Filters and Nested Filters used in Calculate function Using DAX(PowerBI) ( Download)
- Introducing CALCULATE in DAX ( Download)
- Power BI DAX Demystified: Mastering the CALCULATE Function + All, AllExcepts, RemoveFilters & more ( Download)
- DAX FILTER Function ( Download)
- DAX for Power BI - Understanding Filter Context ( Download)
- Measures vs. calculated columns in DAX and Power BI ( Download)
- Power BI DAX Tutorial (4/50) - What is calculate Function ( Download)
- FILTER - DAX Guide ( Download)
