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...
FreemanZ
Super User
Super UserIf 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
- FreemanZ
by [], i mean a measure or an expression resulting a scalar value, like SUM() or COUNT()