Measure with a filter all and a page filter

[JoyceW]

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!

[tamerj1]

Hi @JoyceW 

the Debiteurcode from which table?

[JoyceW]

Sorry, it is Debiteur[DebiteurCode] 

[tamerj1]

@JoyceW 

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

[JoyceW]

Hi, that didn't work unfortunately. 

[tamerj1]

@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.

[JoyceW · Accepted solution]

I figured it out!

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