After adding date table, SUMX no longer shows iterated value per row

[Assenderp]

Hi,

I am trying to show the value of a measure per date. When I use the date from the same table, it works. When I use the date from the date table, even though they have an active relationship, it doesn't work. See image below. 

The measure I am using is:

Ongerealiseerde omzet = CALCULATE(SUMX('Table X';'Table X'[amount]);'Table X'[accountnumber]="84001" || 'Table X'[accountnumber]="84003";'tblCalendar'[Date]>NOW()-1)

I would like the measure to work with the date table. The total calculation is correct, it is just not showing it correctly per specific date period.

Thank you for your help!

[johnt75 · Accepted solution]

The filter you have in the measure on the date table is overriding the filter from the date in the table visual. Try

Ongerealiseerde omzet =
CALCULATE (
    SUMX ( 'Table X', 'Table X'[amount] ),
    'Table X'[accountnumber] = "84001"
        || 'Table X'[accountnumber] = "84003",
    KEEPFILTERS ( 'tblCalendar'[Date] > NOW () - 1 )
)

[Assenderp]

that worked, thank you very much for the explanation and the solution!