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

Hi,

 

You could use something like below.

 

Table_Expr:= SUMMARIZE(FILTER(Table, Table[Status]<>"Works Completed"), Table[Has certificate expired], "Count", COUNT(Table[Has certificate expired]))

Best Regards,
Vignesh M

If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue :)