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