Get startedGet started for free

Security filtering

Did you notice that Distinct City Count did not change in the last exercise? The RLS you created used fields from the Dim_Employee table and automatically filters data within the fact table, but Distinct City Count counts values in the dimensional table Dim_City.

RLS does not access this data unless we apply security filtering in both directions. Your job is to update this so the correct value is displayed.

If you lost progress open workbook 2_3_security_filtering.

This exercise is part of the course

Intermediate DAX in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise