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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
