Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
JoyceW
Helper II
Helper II

Measure with a filter all and a page filter

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!

1 ACCEPTED SOLUTION

I figured it out!

 

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

View solution in original post

6 REPLIES 6
tamerj1
Super User
Super User

Hi @JoyceW 

the Debiteurcode from which table?

Sorry, it is Debiteur[DebiteurCode] 

@JoyceW 

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"))

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.