How to Count from two different table Un-matched record with New table

Hi Rakesk13,

Thank you for providing the details.

I tried reproducing the scenario using the sample data and DAX shared in the post. With the provided data, I was able to reproduce the unmatched counts, but the results don't align with the expected output (QW = 5/5 and RR = 3/1). It appears that the sample data and the expected results may not be consistent (for example, some matching EMP IDs have different Relation values across the two tables).

Could you please share a reproducible .pbix file or a correct sample dataset that exactly reflects the issue you're facing? That will help us reproduce the problem accurately and provide the appropriate solution.

Hope this helps. If you have any doubts regarding on this thread, please feel free to reach out to us. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.