Forum Discussion
Ignore page level filter
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
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]))
