Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Inactive relationships : How to get the ManagerSK?

I have the following schema :

 

I am hiding the FactEmployee in my model and have two relationships as you see :

  • Active : EmployeeSK(FactEmployee) - EmployeeSK(DimEmployee)
  • Inactive : ManagerSK(FactEmployee) - EmployeeSK(DimEmployee)

I would like to get the ManagerSK in my report but my FactEmployee will be hidden.

Need Help
Tips and Tricks

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Also, can you provide more inforamtion, like do you just want to use the ManagerSK column in slicer or you want to create some measure using the inactive relationship?

     

    Have you explored the USERELATIONSHIP Dax function  or TREATAS ?

     

    Thanks,

    Nishanth.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I am using it in a slicer and for a measure.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        would you be able to share the report to understand the issue further. Or a sample of the data with expected result.