Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
IN, AND and OR. table[column] IN {"a", "b"} is true when the value is any item of the list, the same as two conditions joined with || (OR). && (AND) needs both conditions true on the same row, and one column can't hold two values at once.
Busy Channels = CALCULATE([Orders], orders[channel] IN {"Online", "Partner"})Brightline is thinking about a separate catalogue for office goods: the Paper & Print and Desk Supplies categories. The buyer wants their combined revenue by region.
Write the measure Office Revenue on order_items: [Revenue] from products in the Paper & Print or Desk Supplies category. The matrix shows it by region next to [Revenue].
Matrix
Updates as you typeLoading the Brightline model…
Language
Full plan
Power BI ✓ · Excel and SQL also included
Cancel anytime · 14-day full refund · Secure payment by Stripe