Forum Discussion
One-to-one wrong filter
Grieclolu Right, I used your 2 tables originally, not a single employee in Gender that matches with Terminations. Check it yourself in the updated PBIX attached below signature. Gender3, Table3, Page3.
Grieclolu I understand but if all of your terminated employees are in your "Gender" table then they would all be counted and if your terminated employees are NOT in your "Gender" table, then how in the world do you know their Gender to begin with? See the dilemma here?
Greg_Deckler I belive is correct that all the terminated are present in the gender table.
Let's make another example:
i have 4 emoloyees in Table 1, A, B, C, D; A and B are male, while C and D female.
then i have 2 employees in table 2 (terminations), A and D.
My expectation is that, by creating the relationship, A and D could automaically be clustered as male (A) and female (B).
Can you do something like this?
Many thanks 🙂
Grieclolu Right, I used your 2 tables originally, not a single employee in Gender that matches with Terminations. Check it yourself in the updated PBIX attached below signature. Gender3, Table3, Page3.
Grieclolu So I implemented your scenario and it 100% works. See attached PBIX, Gender2, Table2, Page 2.
Greg_Deckler Perfect, in this example it works, so you see the result i want. Now, how can fix the previous example? Or any other bigger dataset?
Many thanks
Grieclolu See attached PBIX. I added user E to terminations list and you can see that since there are no matching records for E in Gender2 table, you get a blank in your donut chart. My suspicion is that you don't actually have all of the terminated employees in your Gender table or that you have trailing spaces or something in your data that is causing the records to be unmatched between the two tables.
Greg_Deckler thanks for your efforts and suggestions, but i don't thing the problem is linked to unmethed date. I double checked it, and you also have my two tables i shared with you (you also use in pbix), so you can chack by yourself.
Do you have any other suggestion?Thanks a lot, Luca