Filtering rows in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ dax_lod_result

intermediate

DAX Filter with CALCULATE and FILTER

Given a Sales table with columns Product and SalesAmount, what is the result of this DAX measure?

Filtered Sales = CALCULATE(SUM(Sales[SalesAmount]), FILTER(Sales, Sales[Product] = "Bike"))

Assuming the Sales table has these rows:

• Bike, 100
• Car, 200
• Bike, 150
• Boat, 300

What is the value of Filtered Sales?

Power BI

Filtered Sales = CALCULATE(SUM(Sales[SalesAmount]), FILTER(Sales, Sales[Product] = "Bike"))

A 250

B 750

C 450

D 100

💡 Hint

Only sum the SalesAmount where Product is exactly "Bike".

The FILTER function limits rows to those where Product is "Bike". The SUM then adds 100 + 150 = 250.

❓ visualization

intermediate

Best Visualization for Filtering by Date Range

You want to create a report page where users can filter sales data by a date range interactively. Which visualization component is best suited for this purpose?

A Stacked bar chart showing sales by product

B Slicer with a date range slider

C Card visual showing total sales

D Table visual listing all sales transactions

💡 Hint

Think about which visual lets users pick a range of dates easily.

A slicer with a date range slider allows users to select start and end dates to filter the report dynamically.

❓ data_modeling

advanced

Filtering Rows in a Related Table

You have two tables: Orders and Customers. Orders has a CustomerID column related to Customers. You want to create a measure that sums Order Amount only for customers in the "Premium" segment. Which DAX expression correctly filters Orders based on Customers segment?

A CALCULATE(SUM(Orders[OrderAmount]), Orders[Customers[Segment]] = "Premium")

B SUM(Orders[OrderAmount]) FILTER(Customers, Customers[Segment] = "Premium")

C SUMX(FILTER(Orders, RELATED(Customers[Segment]) = "Premium"), Orders[OrderAmount])

D CALCULATE(SUM(Orders[OrderAmount]), FILTER(Customers, Customers[Segment] = "Premium"))

💡 Hint

Use RELATED to access columns from the related Customers table inside FILTER on Orders.

Option C filters Orders rows where the related Customer's Segment is "Premium", then sums OrderAmount. Other options have syntax errors or incorrect filter context.

🔧 Formula Fix

advanced

Identify the Error in DAX Filter Expression

What error will this DAX expression cause?

Filtered Sales = CALCULATE(SUM(Sales[SalesAmount]), FILTER(Sales, Sales[Product] == "Bike"))

A SyntaxError due to '==' operator

B No error, returns sum of Bike sales

C TypeError because SalesAmount is not numeric

D Filter returns empty table, so result is blank

💡 Hint

Check the comparison operator used in DAX.

DAX uses a single '=' for equality, not '=='. Using '==' causes a syntax error.

🧠 Conceptual

expert

Effect of Row-Level Security on Filtering

In a Power BI report with Row-Level Security (RLS) applied to the Sales table, what happens when you apply an additional filter on Sales[Region] = "West" in a visual?

A The visual shows no data because filters conflict

B The visual ignores RLS and shows all West region sales

C The visual shows all sales the user can see, ignoring the West filter

D The visual shows only sales in the West region that the user is allowed to see per RLS

💡 Hint

Think about how RLS and report filters combine.

RLS filters data first, then report filters apply. So the visual shows data allowed by RLS and further filtered by Region = "West".