Ignore page level filter

[Anonymous]

Hi everyone

I created a column using the following:

Blank date = IF('Assurance Actions'[Target completion date]=BLANK(),"No target completion date",'Assurance Actions'[Target completion date])

It identifies the blank cells in the Target Completion date column and lists the blank cells as " No target completion date".

I have created a visual for it counting the number of items with " No target completion date" but when copying it over to a tab containing existing visuals and a specific page level filter active , it no longer works.

The specific filter applied relates to a "Assurance reference" column where I have selected specific items to filter on for the page.

What can I do for the "No target completion date"visual to ignore the page level filter?

[Tahreem24]

@Anonymous ,

With the help of ALL() you can ignore the filters.

Refer this post it may help you to understand it better:

https://community.powerbi.com/t5/Desktop/Ignore-page-level-filter-in-Measure/m-p/470711

[Anonymous]

@Tahreem24 

Sorry but I am lost, should I use the solution as in the link,IE CALCULATE instead of using IF and incorporate ALL into it?

[v-xuding-msft]

Hi @Anonymous ,

Is "Blank date" a column or a measure? And how do you count the blank cell? You create a formula? or you use count values in the field?

Can you please share some sample data and your expected output? We will understand more clearly.

[Anonymous]

@v-xuding-msft 

Please refer to Power BI file - Ignore Page Filter 

I need the card visualisation to ignore the "Missed Deadline" page filter. The filter needs to remain as a page filter as there is other visualization which rely on it (not included in this file).