selecting range date where measure is different from date to date is not summing up values

[Anonymous]

Hello everyone

 

i have 2 formulas inside my measure

old way = SUM(RevenueTable[Total])

this was the formula from beginning of my dataset until october 3 2022

so on october 3 2022 and forth, 
new formula = SUMX(Revenuetable2,[QTTY] * [Amount])



so my measure is 
total revenue = 

VAR oldway = IF(MAXX(ALLSELECTED('Calendar Table'),'Calendar Table'[Date]) < DATE(2022,10,3) ,SUM(RevenueTable[Total]),0)

VAR newway = IF(MAXX(ALLSELECTED('Calendar Table'),'Calendar Table'[Date]) >= DATE(2022,10,3) ,SUMX(Revenuetable,[QTTY] * [Amount]),0)

VAR revenue =

oldway + newway

it work fine on single selected date 

but if i selected from september 26 to october 9, 
it wont give me the sum of both

 
if selected october 3 and above, it gave me new correct:

if selected september 26 till october 2 give me old corrrect :

 

now if i select all, it gives me this:

 
as you see it wont give me the sum it just gives me the new formula is apllied

please help

[amitchandak · Accepted solution]

@Anonymous , Try a measure like , Unsing filter add both

calculate(SUM(RevenueTable[Total]),Filter('Calendar Table','Calendar Table'[Date] < DATE(2022,10,3) )) +

calculate(SUMX(Revenuetable,[QTTY] * [Amount]),Filter('Calendar Table','Calendar Table'[Date] >=  DATE(2022,10,3) ))