Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculate true/false and date

Hello,

 

I'm stuck at a DAX calculation. I need to calculate how many items are open in a column named "Closed". The open values have the status False. The value is linked to a field called "closuredate" and the date is set tot 31-12-9999. Example is below: 

 

 

How can i do this ? If i use the next dax i'll get the numbers in a table:

Openstaande meldingen = COUNTROWS(FILTER(Incident; Incident[closed] = FALSE()))
 
but when i use it in a visual and there is a date slicer it will return 0 because the closure date is 31-12-9999
 
 
Who can help me to solve this issue.

2 Replies

  • HI Anonymous ,

     

    Which date column are you using in your slicer?

     

    Thanks,

    Pragati

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Pragati11,

       

      Im using the calldate (date of making) column in my slicer.