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

How to Apply Slicer filter to Un-matched records of two different table

Can you help on this please.

Hi Team,

I have data like this:

Emp Details:

EMP SUMM :

I need to apply Relation filter to visualization are not changing/applying .

1)

More test =

var _distDet =

DISTINCT(Sheet1[EMP ID _DE]   )              //unique Details Ids

var _distSumm =

DISTINCT('Sheet1 (2)'[EMP ID])                     //unique Summary Ids

var _commonIDs =

INTERSECT(_distDet, _distSumm)                  //unique Ids found in both tables

var _unqDet =

COUNTROWS(_distDet) - COUNTROWS(_commonIDs)     //count of unique Details Ids not in common table

var _unqSumm =

COUNTROWS(_distSumm) - COUNTROWS(_commonIDs)    //count of unique Summary Ids not in common table

RETURN

_unqDet

//+ _unqSumm

2)

More test_Unmatch =

var _distDet =

DISTINCT(Sheet1[EMP ID _DE]   )              //unique Details Ids

var _distSumm =

DISTINCT('Sheet1 (2)'[EMP ID])                     //unique Summary Ids

var _commonIDs =

INTERSECT(_distDet, _distSumm)                  //unique Ids found in both tables

var _unqDet =

COUNTROWS(_distDet) - COUNTROWS(_commonIDs)     //count of unique Details Ids not in common table

var _unqSumm =

COUNTROWS(_distSumm) - COUNTROWS(_commonIDs)    //count of unique Summary Ids not in common table

RETURN

//_unqDet

+ _unqSumm

I do have two visualization  More test and More test _Un-Matched ,which are un-match record of each other table.

I am trying to apply Slicer but its not applying Properly on  visualization ,

Relationship between table :

 There  is Many to One relationship between the table.

Both table have Relation Field ,we can use any one of them to fiter.

Expected Result looking for:

If I select QW or RR from Slicer it should filter Un-Matched record from More test and Moretest_Unmatch  from two different table.

For EMP details table:

QW Count :5

RR Count: 3

For Emp Summ table:

QW Count: 5

RR Count  1

Please can you help on this. 

Thanks & Regards,

Rakesh Jadhav