Relation issue

Hi,

 

I have following relation

 

where invoice and Store ID concatanate with SSummar and Sales Table with many to one in both direction

then i have bmcalendar with sales table many to one single direction 

 

when i take invocie_dt from ssummary table only march 2023 to filter net_AMT i got correct result

 but when i take march 2023 from bmcalendar table and filter i got incorrect result

 

 

interesting this this is happened some month like march 2023, november 2022 etc. other than those most months are ok. so how i really identify the issue

 

 

I drill down and found that 29-03-2023 has issue. in my data view i have 4 invoises but in visual when i use bmcalendar is not reading one imoive which is invoice number INVOICE_NO = 0023032900009 and has Net_amt is 985

0023032900009
0023032900024
0023032900004
0023032900023

 

 

so when i filter invoide_dt from ssummary table it has no issue but when filter using bmcalendar table it not getting one invoice. i checked this 0023032900009 is same as other 3 invoice rows and is in data view. but not showing in visual

 

 

 

what could be the possibility issue for this specific day in month of calendar.  please help

 

thanks