Ignore page level filter

[Anonymous]

Hi,

My measure is not showing because there are some page level filters activated. Removing the filters is not an option.

I tried to ignore the filters by using ALL function but it is not working as expected.

Realized budget = CALCULATE(SUM('Table2'[Value]),

FILTER('Table2','Table2'[Column]="Realized budget"),

FILTER(ALL('Table1'), 'Table1'[Filter2] = "Kyllä" || 'Table1'[Filter2] = "Ei"),

FILTER(ALL('Table1'), 'Table1'[Filter2] <> "Arkistoitu"))

Filter 1 and 2 are on page level.

You can find the pbix here. 

I'm really grateful if somebody has the time to take a look at this.

Julia

[lbendlin · Accepted solution]

The measure in your post doesn't match the measure in the PBIX.

Anyway, here's a starting point:

Realized budget = CALCULATE(SUM('Table2'[Value]),

ALLEXCEPT(Table1,Table1[Field],Table1[Project]))

[Anonymous]

@lbendlin, your suggestion solved the issue. Cheers 🙂