Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Ignore page level filter

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]) ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
v-xuding-msft
Community Support
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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).