Forum Discussion
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
3 Replies
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)
)
- 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()
