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 secti...
Need Help
  • 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

drewlewis15's avatar
drewlewis15
Solution Specialist
8 years ago

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

RaulPBI's avatar
RaulPBI
Helper II
8 years ago

I'm afraid no. More details?

  • drewlewis15's avatar
    drewlewis15
    Solution Specialist
    8 years ago

    What measure are you currently using?

    • RaulPBI's avatar
      RaulPBI
      Helper II
      8 years ago

      I use "distinctcount" to count different values (worker´s number) in both fact tables, but the issue is that one single value can appear in both tables. So, how do you do to consider this repeated value as one value?

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        HI RaulPBI,

         

        Can you share some sample data for test?

         

        Regards,

        XIaoxin Sheng