dax for tasks

[Anonymous]

hi
i want to find the count of where tasks=dpdswapit and task template id= engvisit
from tasks table

[amitchandak · Accepted solution]

@Anonymous ,

Like

Calculate(count(Table[tasks]) , filter(Table,Table[tasks]="dpdswapit"  && Table[task template id]= "engvisit"))

or

Calculate(count(Table[tasks]) , filter(Table,Table[tasks]="dpdswapit"  && Table[task template id]= "engvisit"),DATESMTD(dateadd('Date'[Date],-1,MONTH))

[Anonymous]

hi
i am getting an error