Forum Discussion

FreemanZ's avatar
FreemanZ
Super User
3 years ago

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's avatar
    Saravanan_ameer
    Frequent Visitor
    3 years ago
    Column = CALCULATE([],USERELATIONSHIP('DEPARTMENT'[Department Name],Presents[dept_name]))
     
    BUT getting error
    • FreemanZ's avatar
      FreemanZ
      Super User
      3 years ago

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