Forum Discussion

RaulPBI's avatar
RaulPBI
Helper II
8 years ago
Solved

one id code used in different tables

hi everybody

 

I have three tables, one of them is dimensional (id and names of my employees) and it has unique values. The others are fact tables, with diffenrent values (hours in differents sections or activities). I want to calculate total number of employees and I had some duplicated value because some people work in more than one activity. So, the measure shows more employees that I really have. Any idea about how to calculate this properly?

 

Thank you in advance.

  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi RaulPBI,

     

    I think you need to create a mapping table to store mapping records and used to convert different id.

    Sample:

    Index Table1 ID Table2 ID
    1 123 abc
    2 456 def

     

    Regards,

    Xiaoxin Sheng

9 Replies

  • drewlewis15's avatar
    drewlewis15
    Solution Specialist

    What measure are you currently using?  Would CALCULATE(DISTINCTCOUNT... solve your issue?