Forum Discussion

Kate_D's avatar
Kate_D
Frequent Visitor
1 year ago
Solved

Calculated Column using RELATED

Hello. I need help with a calculated column. It returns a row with a manager’s name and a row with blank value when adding to a table.

 

Manager Name = IF('Department [Column.ManagerId] = RELATED('Employee'[Column.id]), RELATED(‘Employee’ [Column.Name]))

 

I am using three datasets: Company, Department, Employee.

Company and Department datasets have many to many relationship due to no unique values available in both datasets. Employee dataset has one to many relationships with Company and Department datasets.

 

 

Thank you.

Need Help

6 Replies

  • parry2k's avatar
    parry2k
    Super User
    1 year ago

    Kate_D it will be easier to share raw data for department and employee to understand why you are getting blank value. DAX expression seems to be correct and should work, only reason it will return empty value if the column value doesn't match.

    • Kate_D's avatar
      Kate_D
      Frequent Visitor
      1 year ago

      I can't share the raw data. Thank you

  • parry2k's avatar
    parry2k
    Super User
    1 year ago

    Nobody is saying share raw data, you can always create dummy data. Good luck. You are expecting to get support and not able to provide the information, not sure what else to say.