Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
106 | |
86 | |
81 | |
73 | |
71 |
User | Count |
---|---|
112 | |
100 | |
98 | |
72 | |
66 |