Level 3 · Several filters at once, and IN

Real tickets rarely need one filter. Kevin’s number has two conditions, on two tables: the order’s channel and the customer’s segment.

What you are working in

This is a practice DAX engine built for this site, not Power BI; it fills the matrix cell by cell with your measure and checks each cell. In Power BI Desktop: Home → New measure, type the formula (Shift+Enter starts a new line in the formula bar), press Enter, and add the measure to the matrix.

Several filter arguments mean AND

Digital Business Sales =
CALCULATE(
    [Sales],
    orders[channel] IN { "web", "app" },
    customers[segment] = "business"
)

CALCULATE applies every filter argument at once. A row of order_items counts only if its order is web or app and its customer is a business. Filters on different columns never cancel each other; they intersect.

IN { } for a list of values

orders[channel] IN { "web", "app" } keeps the rows whose channel is any of the listed values. The curly braces build a small one-column table. It is the same as writing orders[channel] = "web" || orders[channel] = "app", and it reads better as the list grows. To exclude instead, wrap it: NOT ( orders[channel] IN { "marketplace" } ).

OR inside one column, AND across columns

A single boolean filter argument may test columns of one table only, and no measures. Inside it you can use ||, && and IN freely. To combine two tables with OR (web orders or business customers), you need a table filter, which comes in the next level with FILTER. Combining conditions with AND is easy: give each its own argument, as here.

Filters travel along relationships

customers[segment] lives in customers, not in orders. That’s fine: the filter lands on customers, the relationship carries it to orders, and the next one to order_items, where the sum runs. The Sales measure adds its own status filter inside, so the result is completed sales only. Nested CALCULATEs simply add up their filters.

Common mistakes

• && on the same column. orders[channel] = "web" && orders[channel] = "app" asks for orders that are both at once: none.
• Case and spelling. Text matches ignore case in DAX, so "Web" works, but "website" matches nothing.
• Filtering the visual instead. A channel slicer would also change the Sales column. Kevin wants both numbers side by side, so the filter belongs inside the measure.