Forum Discussion

cottrera's avatar
cottrera
Post Prodigy
6 years ago
Solved

Multiple count if

Hi    I need to use dax to carry out a count if function. I have a property safety table and need to count the number of properties where the 'Cert has expired' column says 'Expired' however I also...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Try

    calculate(count(table1[Ref]),filter(table1,table1[Has certificate expired]='Expired' && table1[Status]!='Works Completed'))
amitchandak's avatar
amitchandak
Super User
6 years ago

Try

calculate(count(table1[Ref]),filter(table1,table1[Has certificate expired]='Expired' && table1[Status]!='Works Completed'))