Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Active relationship

Hi Expects,


I need apply the slicer for the department.If i select the depatment name it needs show both the table details but due to more than 1 active relationship i am not getting the filtered result for both the table only one result i am getting.



If i select the department slicer only absent employee details are getting filtered but i need both the present and absent should get filtered.


Please help

Super User
Super User

If you need to filter Presents table with Department table, you need USERELATIONSHIP to temporally activate their relationship, the code it like this:



    USERELATIONSHIP(a column from Department, a column from Presents) 


Column = CALCULATE([],USERELATIONSHIP('DEPARTMENT'[Department Name],Presents[dept_name]))
BUT getting error

by [], i mean a measure or an expression resulting a scalar value, like SUM() or COUNT()

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.