cancel
Showing results for 
Search instead for 
Did you mean: 
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
Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors