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!
Solved! Go to Solution.
I figured it out!
Voorraadwaarde =
CALCULATE (
SUM ( Grootboekmutaties[Bedrag] ), REMOVEFILTERS(Debiteur[DebiteurCode]),
filter(GrootboekCategorieNiveau2, GrootboekCategorieNiveau2[GrootboekCategorieOmschrijvingNiveau2] = "Voorraden"))
Sorry, it is Debiteur[DebiteurCode]
You can try to CROSSFILTER the relationship with Debiteur table to NONE
Hi, that didn't work unfortunately.
@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.
I figured it out!
Voorraadwaarde =
CALCULATE (
SUM ( Grootboekmutaties[Bedrag] ), REMOVEFILTERS(Debiteur[DebiteurCode]),
filter(GrootboekCategorieNiveau2, GrootboekCategorieNiveau2[GrootboekCategorieOmschrijvingNiveau2] = "Voorraden"))