Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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!  
  • 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.

     

    ;) 

4 Replies

  • 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's avatar
      Anonymous
      Not applicable

      It worked Thank You!

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft 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

    • Anonymous's avatar
      Anonymous
      Not applicable

      yeah sure, can you paste your measure!