Dax formula won't ignore the last dropdown filter

[wl2020]

I am working on a report in Power BI where I have 4 filters to sort the data, and for the report to function properly, the revenue formula needs to ignore the last filter (indicator) so that I can make a comparison. I have tried

Profit =
CALCULATE (
    [Caravan] + [PKW] + betrag[sleistung] + betrag[smaterial] + betrag[sumsatz],
    ALL ( table[indicator] )
)

But it is not working. Any idea what could be the problem?

[az38 · Accepted solution]

Hi @wl2020 

try SUMX(), like

Profit =
CALCULATE (
SUMX(table,([Caravan] + [PKW] + betrag[sleistung] + betrag[smaterial] + betrag[sumsatz])),
ALL ( table[indicator] )
)