Unexpected behavior of calculated column

Hi community,

we have a simple data model with tables order, order item and item. For statistical purposes we want to have the quantity sold for the item. If I add calculated column to article it works. If I then filter the visual by date from the order, that column is not filtered.
Could anyone help to fix the problem, please?

DAX: Verkaufte Menge = SUMX(RELATEDTABLE(tAuftragPosition), tAuftragPosition[fAnzahl])

 

 

Bye Magnus