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
    Icon for Community Support rankCommunity 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).