Active relationship

[Saravanan_ameer]

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

[FreemanZ]

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

CALCULATE(

    [],

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

)

[Saravanan_ameer]

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

BUT getting error

[FreemanZ]

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