A Measure That Ignores Page Level Filters

[Anonymous]

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!  

[Nickgastaldi · Accepted solution]

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]

It worked Thank You!

[v-jiascu-msft]

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. 

Best Regards,
Dale

[Anonymous]

yeah sure, can you paste your measure!