source data are from two different table with a cut-off date

My data source are from two tables with a cut-off date and I need to calculate from those two tables, then I write the measure as below.  I can get an answer if I choose a date before 2023/6/30, how...