cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Anonymous
Not applicable

A Measure That Ignores Page Level Filters

I have a page with some page level filters

 

I have a measure 

Measure = CALCULATE(AVERAGE(CustomerData[Score]),
FILTER(ALL(CustomerData), CustomerData[ProductLine] = "xxx"),
FILTER(ALL(CustomerData), CustomerData[Tenure] > 123))
 
on an empty page the above measure value is 2.45
 
but if I place this on a page with page level filters then the value is 2.25, so the page filters are affecting this value
 
Can someone please fix my measure such that it always displays 2.45 rgeardless of any filters on the page.
 
Thank You!  
1 ACCEPTED SOLUTION
Nickgastaldi
Resolver I
Resolver I

i can be very wrong, but i believe that this 

Measure = CALCULATE(AVERAGE(CustomerData[Score]),
FILTER(ALL(CustomerData), CustomerData[ProductLine] = "xxx"),
FILTER(ALL(CustomerData), CustomerData[Tenure] > 123))

actually doesnt do what you expect it to do, the second filter is actually overwriting the first one,

 

you should try this:

Measure = CALCULATE(
                  AVERAGE(CustomerData[Score]),
                  FILTER(ALL(CustomerData), 
                                     CustomerData[ProductLine] = "xxx" 
                                      && CustomerData[Tenure] > 123)
)

also, the ALL filter will ignore all filter outside the CALCULTE context, so is highly improbable that what is bugging your calculation is the page level filter; try fixing the measure as above and if you can help us with some context, example, demo, anything more material.

 

😉 

View solution in original post

4 REPLIES 4
Nickgastaldi
Resolver I
Resolver I

i can be very wrong, but i believe that this 

Measure = CALCULATE(AVERAGE(CustomerData[Score]),
FILTER(ALL(CustomerData), CustomerData[ProductLine] = "xxx"),
FILTER(ALL(CustomerData), CustomerData[Tenure] > 123))

actually doesnt do what you expect it to do, the second filter is actually overwriting the first one,

 

you should try this:

Measure = CALCULATE(
                  AVERAGE(CustomerData[Score]),
                  FILTER(ALL(CustomerData), 
                                     CustomerData[ProductLine] = "xxx" 
                                      && CustomerData[Tenure] > 123)
)

also, the ALL filter will ignore all filter outside the CALCULTE context, so is highly improbable that what is bugging your calculation is the page level filter; try fixing the measure as above and if you can help us with some context, example, demo, anything more material.

 

😉 

Anonymous
Not applicable

It worked Thank You!

v-jiascu-msft
Microsoft
Microsoft

Hi @Anonymous, 

 

According to my test, it seems impossible since you have clear all the filters on [CustomerData]. Can you share a dummy sample? Please upgrade the Desktop to the latest version. Please refer to my test. 

A-Measure-That-Ignores-Page-Level-Filters

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

yeah sure, can you paste your measure!

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors