How to make Slicer Work on Inactive Relationship in PowerBI?

[meetbardoliya47]

0

I’m working on a Power BI model with the following relationships:

DimManager is connected to DimProjects through a direct relationship (via ManagerID).

DimProjects contains project-level details and is connected to DimTasks through ProjectID.

DimTasks contains task-level details, including TaskID and ProjectID.

Problem:
When I add a slicer for ManagerName from DimManager, it filters the DimProjects table as expected. However, it does not propagate to the DimTasks table, meaning that the tasks shown are not filtered by the selected manager.

Relationships in the Model:

DimManager → DimProjects (Active, via ManagerID). DimProjects → DimTasks (Inactive, via ProjectID).

Expected Behavior: If I select "Alice" in the slicer, only Task 1 (associated with Project A) should appear in the tasks table.

Question:

1. Why does the filter on ManagerName fail to propagate to the DimTasks table?
2. How can I fix this so that filtering on ManagerName in the slicer filters the tasks table correctly?

[Jai-Rathinavel · Accepted solution]

Hi @meetbardoliya47 , You have to use USERELATIONSHIP() function in a DAX measure to activate the relationship between Dim Project and Dim Task table. Refer below documentation 

Link to documentation