Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 to ingore (subtract) and properties where the 'Status' column says 'Works Completed'
I have attached an example of the table for which the result I expect is 6
Ref | Status | Has certificate expired |
377 | Works Completed | Expired |
212 | Expired | |
145 | Expired | |
238 | Expired | |
249 | Expired | |
98 | Works Completed | In date |
286 | Works Completed | In date |
106 | Works Completed | Expired |
115 | Job Scheduled | In date |
261 | In date | |
179 | In date | |
346 | In date | |
254 | Works Completed | Expired |
209 | Expired | |
76 | Job Scheduled | Expired |
315 | Job Scheduled | In date |
226 | In date | |
80 | Works Completed | In date |
50 | Works Completed | In date |
thank you
Solved! Go to Solution.
Try
calculate(count(table1[Ref]),filter(table1,table1[Has certificate expired]='Expired' && table1[Status]!='Works Completed'))
Try
calculate(count(table1[Ref]),filter(table1,table1[Has certificate expired]='Expired' && table1[Status]!='Works Completed'))
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 🙂
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
96 | |
92 | |
86 | |
69 |
User | Count |
---|---|
161 | |
126 | |
119 | |
109 | |
95 |