Filtering values are not match when using two table and measures

[icrishanka]

Hi,

I use two tables with two measures (need to use, I am using switch method) like following image, 

Please help 

1. Total_Defect = SUM(Ex_Machine_Count[qty]))

2. Total_Defect_L =

CALCULATE(

    SUM(Ex_Machine_Count[qty]),FILTER('04.Hand','04.Hand'[HandID]=="L")

)

Issue is, when I select the one of cell value, it is not mtach with another table value(Plz see following image as example)

1. Initial : this is ok (Add L + R)

2. This is ok : filtering with size

3. This is wrong : Filter size with L

[ChiragGarg2512]

@icrishanka , It will not match because total_defect is the sum of qty. So, when a value in L is selected total_defect shows the value for size 7.0. Beacuse for that value of L there is also a value of R for which the value of total_defect is as shown. 

Eveything is working as it should.

Thank You