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

Anonymous — Fri, 14 Oct 2022 00:31:28 GMT

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

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

amitchandak — Fri, 14 Oct 2022 01:50:24 GMT

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) ))

topic Re: selecting range date where measure is different from date to date is not summing up values in DAX Commands and Tips

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

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