Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Dear Team,
I have a table
Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Count of NotCompleted |
Completed | NotCompleted | Completed | NotCompleted | NotCompleted | Completed | 3 |
Completed | Completed | NotCompleted | Completed | Completed | Completed | 1 |
How to write a dax function to calculate the count of NotCompleted?
Thank You
Solved! Go to Solution.
HI @asodhani
If you don't mind a bit of hardcoding this calculated column will work
Column = VAR S = "NotCompleted" RETURN IF('Table3'[Column 1]=S,1) + IF('Table3'[Column 2]=S,1) + IF('Table3'[Column 3]=S,1) + IF('Table3'[Column 4]=S,1) + IF('Table3'[Column 5]=S,1) + IF('Table3'[Column 6]=S,1)
Otherwise, unpivot the data to rows and you can sum over a single column
Hi @asodhani
Please give this a try.
Column = IF('Table3'[Column 1]="NotCompleted",1) + IF('Table3'[Column 2]="NotCompleted",1) + IF('Table3'[Column 3]="NotCompleted",1) + IF('Table3'[Column 4]="NotCompleted",1) + IF('Table3'[Column 5]="NotCompleted",1) + IF('Table3'[Column 6]="NotCompleted",1)
HI @asodhani
If you don't mind a bit of hardcoding this calculated column will work
Column = VAR S = "NotCompleted" RETURN IF('Table3'[Column 1]=S,1) + IF('Table3'[Column 2]=S,1) + IF('Table3'[Column 3]=S,1) + IF('Table3'[Column 4]=S,1) + IF('Table3'[Column 5]=S,1) + IF('Table3'[Column 6]=S,1)
Otherwise, unpivot the data to rows and you can sum over a single column
I can only do VAR.S but then it asks me for a column name. also I am unsure how to add the Return Formula after that.
Will be great if you can assist
Hi @asodhani
Please give this a try.
Column = IF('Table3'[Column 1]="NotCompleted",1) + IF('Table3'[Column 2]="NotCompleted",1) + IF('Table3'[Column 3]="NotCompleted",1) + IF('Table3'[Column 4]="NotCompleted",1) + IF('Table3'[Column 5]="NotCompleted",1) + IF('Table3'[Column 6]="NotCompleted",1)
How to unpivot data to rows? I have this table directly coming from a ERP Database
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
65 | |
64 | |
56 | |
39 | |
27 |
User | Count |
---|---|
85 | |
59 | |
45 | |
43 | |
38 |