Need one Visual to ignore a Page Filter

[StuartSmith]

I have a page filter that is applied to all the visuals on a report, but I need one visual not to be affected by the page filter.  I could remove the page filter and add individual visual filters to all the visuals i want affected and leave the 1 visual without a filter, but wondering if there is a way to create a measure that will disregard the page filter.  I have tried "ALL", but that doesnt work until i remove the page filter, which ideally i want to keep.

Hope that makes sense and thanks in advance.

[PaulDBrown]

 I think you cannot override a page level filter, but I may be wrong (and I would be more than happy to be corrected). The workaround would be applying the filter on a visual level and remove the page level filter, as you yourself have suggested.

[StuartSmith · Accepted solution]

Yer, I've gone down the visual level filter approach.  Would be a nice future feature to allow visual\measures to ignore page level filters.

[TheoC]

Hi @StuartSmith 

Just to confirm, when you used ALL, you used it in the context of: "CALCULATE ( ALL ( 'FilterTableName' ) , [Your Measure] )" or "CALCULATE ( [Your Measure] , ALL ( 'FilterTableName' ) )"?

Cheers in advance.

Theo

[StuartSmith]

So i have a table called headcount that has columns "Job ID" and "Anticiapted Start Date".  The report has 4 tabs Q1, Q2, Q3 & you guessd it, Q4.  Each tab has a page level filter called "Month" (from another table) and for Q1 only shows jobs with a start date in Jan, Fed & Mar, Q2 shows Apr, May & June and so on.  This allows me to show the headcount for each Q..  The problem is, I have a requirement to be able to show previous Q headcounts on other Q Tabs and perform measures on previous Q Headcount totals.

So I have been trying something like the below, but it only displays (Blank) and not "15"

TEST = CALCULATE ( COUNTROWS( 'HR Data' ), ALL('HR Data'), FILTER ( 'Dates', Dates[Month Name]= "March" ) )

I could try removing the page level filter for "Month" and add visual level filters on each visual, but its not ideal.  Any ideas?

[AllisonKennedy]

@StuartSmith  If your page level filter is for month, then you need to use Month in the ALL() function:

TEST = CALCULATE ( COUNTROWS( 'HR Data' ), ALL('Dates'[Month]), FILTER ( 'Dates', Dates[Month Name]= "March" ) )

OR

TEST = CALCULATE ( COUNTROWS( 'HR Data' ), FILTER (ALL( 'Dates' ), Dates[Month Name]= "March" ) )

This will only work if the visual you want the filter cleared on does not need any slicing by Month. 

Another option (if you do want to slice by month) would be to duplicate the Dates table and use that duplicated table in the one visual that shouldn't respond to the page level filters. You'll still need the Test measure that clears the filter on the page level date table, but then use the duplicate date table in the other visual. Similar to this problem, but with page level filters instead of cross-highlighting: https://community.powerbi.com/t5/Desktop/Filtering-based-on-subitems/m-p/2358312#M849279