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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Employee
Employee

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.