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 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
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.