Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
So I get why this is happening even though they are the exact same numbers in both columns from both tables:
There are duplicates in my CService table because since a company can have multiple services other than payroll, they will be listed more than once of course. My question is, are they any workarounds to this? I need to be able to make a connection between these two tables based on the Company ID.
Solved! Go to Solution.
@Anonymous,
My mistake, there is a syntax error in my original DAX. Please use DAX below instead, replace CBIZ with your own table.
NewTable = FILTER( DISTINCT( UNION( DISTINCT(CBIZ[CompanyID]), DISTINCT(CService[co]) ) ), NOT(ISBLANK(CBIZ[CompanyID])) )
Regards,
Lydia
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |