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

hi schoden You need something like this, in order to have the correct calculate.

Whit variables is easier and clear. 

 

mesuare =
VAR lastday = PREVIOUSDAY('Table'[Date])
var calculat = CALCULATE(SUM('Table'[value]), 'Table'[Date] = lastday)
return calculat

 

I leave you the .pbix here https://1drv.ms/u/s!AtEkAF7ffIsqg8RU_Q8H3f_rdntrBA?e=b8fdVl