topic Measure with a filter all and a page filter in DAX Commands and Tips

Measure with a filter all and a page filter

JoyceW — Fri, 09 Sep 2022 18:22:19 GMT

Hi,

I have the following measure:

Voorraadwaarde = CALCULATE ( SUM ( Grootboekmutaties[Bedrag] ), FILTER ( ALL ( GrootboekRekening[GrootboekCategorieCodeNiveau2] ), GrootboekRekening[GrootboekCategorieCodeNiveau2] = " 05" ) )

I have a page with a filter on Debiteurcode is not 998.

I want that page filter not to be applied to the above measure. I have tried with ALL(debiteurcode) and ALLEXCEPT, but I can't get it to work. Any help is very much appreciated. Thank you!

Re: Measure with a filter all and a page filter

tamerj1 — Fri, 09 Sep 2022 19:14:06 GMT

Hi JoyceW

the Debiteurcode from which table?

Re: Measure with a filter all and a page filter

JoyceW — Fri, 09 Sep 2022 20:26:13 GMT

Sorry, it is Debiteur[DebiteurCode]

Re: Measure with a filter all and a page filter

tamerj1 — Fri, 09 Sep 2022 21:01:12 GMT

JoyceW

You can try to CROSSFILTER the relationship with Debiteur table to NONE

Re: Measure with a filter all and a page filter

JoyceW — Sat, 10 Sep 2022 11:17:52 GMT

Hi, that didn't work unfortunately.

Re: Measure with a filter all and a page filter

tamerj1 — Sat, 10 Sep 2022 11:56:28 GMT

JoyceW
Yes it won't. Actually the tablr supplied to the visual is prefiltered by the page filter even crossfiltering the relation to non won't restore the rows filtered out by the page filter. I don't know of any method that can do that but I hope others will.

Re: Measure with a filter all and a page filter

JoyceW — Sat, 10 Sep 2022 12:50:27 GMT

I figured it out!

Voorraadwaarde =
CALCULATE (
SUM ( Grootboekmutaties[Bedrag] ), REMOVEFILTERS(Debiteur[DebiteurCode]),
filter(GrootboekCategorieNiveau2, GrootboekCategorieNiveau2[GrootboekCategorieOmschrijvingNiveau2] = "Voorraden"))