Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello everyone,
Is there a way we can group multiple columns and then enforce a COUNTIFS function?
I have multiple columns that I would like to group them into one single column, and then to enforce a countif function. The columns here have a "yes" and "no" answer so it's basically the same for all.
Appreciate the help and support from you guys here! Thank you so much!
Solved! Go to Solution.
Hi @Anonymous ,
You could unpivot these columns as a single column in query editor.
Hi @Anonymous ,
You could unpivot these columns as a single column in query editor.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 9 | |
| 8 | |
| 7 | |
| 6 |