Forum Discussion

schoden's avatar
schoden
Post Partisan
6 years ago

COUNTIF

Hi All,    I am confused why there is variance between these two approach.  To count the member where conditions are: a. status = closed or resolved  b. date is Yesterday   I created measure cl...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

schoden , Try like

CLosed =
CALCULATE(DISTINCTCOUNT(table[member]),filter(table, (table[status]="Closed" || table[status]= "Resolved") && table[Date_Entered_UTC]= TODAY()-1 )
)

  • schoden's avatar
    schoden
    Post Partisan
    6 years ago

    amitchandak  Thanks for your response.

     

    yes I did it that way also  . It gives same result - with and without FILTER

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi schoden u need and if, in order to give a specific behavior with and without filter, try with this 

       

      mesuare = IF(SELECTEDVALUE('Table'[Date])>1,,SUM('Table'[value]), CALCULATE(SUM('Table'[value]), 'Table'[Date] = TODAY()-1))
       
      I leave you the .pbix
       
      thanks and regards