Forum Discussion

icrishanka's avatar
icrishanka
Frequent Visitor
2 years ago

Filtering values are not match when using two table and measures

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

 

1 Reply

  • ChiragGarg2512's avatar
    ChiragGarg2512
    Solution Sage
    2 years ago

    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