Forum Discussion
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.
- Anonymous8 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
- drewlewis15Solution Specialist
What measure are you currently using? Would CALCULATE(DISTINCTCOUNT... solve your issue?
- RaulPBIHelper II
I'm afraid no. More details?
- drewlewis15Solution Specialist
What measure are you currently using?