Forum Discussion

Rakesk13's avatar
Rakesk13
Icon for Advocate II rankAdvocate II
2 months ago
Solved

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

Hi team,   i have data like this :    EMP Details     EMP ID  EMP NAME  AGE AMT 1 A 1 1000 2 B 2 45 3 C 3 2000 4 D 6 3444 ...
Need Help
  • v-abhinavmu's avatar
    v-abhinavmu
    2 months ago

    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.

v-pnaroju-msft's avatar
v-pnaroju-msft
Icon for Community Support rankCommunity Support
2 months ago

Thankyou, parry2k for your response.

Hi Rakesk13,

We appreciate your question on the Microsoft Fabric Community Forum.

Based on our understanding of the issue, please find attached a screenshot and a sample PBIX file that may assist in resolving the matter.

 


We hope the information provided helps to resolve the issue. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you

  • Rakesk13's avatar
    Rakesk13
    Icon for Advocate II rankAdvocate II
    2 months ago

    Hi ,Really Thanks ,its help me out.

     

     

    One small help i need as in screenshot we got Only NA count as 8 which are un-match from EMP-SUMM and EMP_DETAILS table

     

     

     

    And we got count of 3 match between EMP_SUMM and EMP_ADD table

     

    Now I am looking for 8-3 = 5 as count.

    How we can performed calculation for it.

     

    Please can you help on this.

     

    Thanks & Regards,

    Rakesh Jadhav