Select Function Issue

[AbdulNavas]

Hello All,
I have a request. Please help me with this.
I have three tables

1. Stock In (Fabric In
   2.Current Stock
   3.Stock Out (Daily Production FormProduction)

I have made a selection and sum expression from some column which matches the _thisrow (Current Stock)
Expression:

SUM(
SELECT(
Fabric Stock In[Quantity In], AND
([Company Name]= [_THISROW].[Company Name],[Fabric Dia]=[_THISROW].[Fabric Dia],[Fabric Colour]=[_THISROW].[Fabric Colour]
))) -SUM(
SELECT(
Daily Production Form[Kilogram / Pcs], AND
([Company Name]= [_THISROW].[Company Name],[Fabric Type]=[_THISROW].[Fabric Type],[Fabric Dia]=[_THISROW].[Fabric Dia],[Fabric Colour]=[_THISROW].[Fabric Colour]
)))

I have used AND function. I think we should use this IF function Beasue Dia Column Does not match but it showing the same value. I’m totally confused, anyone please help me.