DAX practice: Table Filtering with FILTER
Chapter 7 · 3 questions · included in full access
Question 1 · medium
Count big orders
Solve it in your browserWrite Big Orders: count orders in Sales where Line Total (Units * UnitPrice) is ₹50,000 or more.
Question 2 · hard
High value sales
Solve it in your browserWrite High Value Sales: total sales (Units * UnitPrice) for orders with 25 or more units.
Question 3 · easy
Zero discount orders
Solve it in your browserWrite Zero Discount Orders: count how many orders received 0% discount.
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing