Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Guys,
I have some survey data across lots of columns. The answers are your typical satisfied, not satisified, very satisfied. I want to count the number of each answer across the whole table. Then I'll be able to slice that by position, department etc
Is there a DAX formula for this ?
Many thanks
Hi @Anonymous,
Please show us the table structure as well as sample data, and show us the desired output so that we can test for you.
How to Get Your Question Answered Quickly
Regards,
Yuliana Gu
I think some sample of the data would be great.
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |