Page level filters not applying to visuals that use measures

[Anonymous]

l have two tables - Table1 and Table2. I have set the relationship many to many with filtering direction as both. I have now set a page level filter so that data from Table1 is being filtered by data from Table2. The filters applied are: Table2, column X = Yes and Table2, column Y = People. This works fine on all visuals containing data from Table1 except when the data is a measure. Where a visual (2x cards and 1x table) is displaying a measure, no filters are applied and it is showing all data from Table1.

My measures are:

Measure 1 = IF((SUM('Table1'[column x]<=0),0,(CALCULATE(AVERAGEX('Table1','Table1'[column x]),FILTER('Table1','Table1'[column x]<>0))))

Measure 2 = CALCULATE(IF('Table1'[Measure1]=0,0,CALCULATE(COUNT('Table 1'[column x]),FILTER('Table1',[column x]>0)))

Can someone help me to understand why measures are not being affected by the page level filters applied. I am new to using measures and DAX etc so any help is appreciated. I have tried a number of solutions but not getting anywhere!

Thank you

[Anonymous · Accepted solution]

Hi @Anonymous ,

Measures calculate values based on the current filter context. If the measures are not responding to the page level filters, it might be due to the use of functions like `CALCULATE` which can modify the filter context.

If you want your measures to respect the page level filters, you can use the `ALLSELECTED` function within the `CALCULATE` function to maintain the filters that are currently applied to the report page.

Below is the official link about 'ALLSELECTED':

ALLSELECTED function (DAX) - DAX | Microsoft Learn

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.