Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have this table:
How do I go about:
1. Counting the total amount of all replies by manager (very happy + happy + unhappy etc.)
2. Bucketing the counts by category (count of happy, count of unhappy, etc.) by manager
3. Counting total number of all replies regardless of manager (total number of survey responses)
4. Bucketing total counts by category regardless of manager (count of happy, count of unhappy, etc.)
I'm eventually looking to make some kind of table/matrix that shows by account manager the number of each they have in comparison to the total. So for example the ending result on a small scale would look something like:
Cathy Butler across all categories has 25 "happy" responses
Ryan Cundiff across all categories has 20 "happy" responses
There are a total of 500 responses between all managers regardless of whether it's happy/unhappy/in between so these two together would account for 9% of all happy responses (45/500)
Thanks!
Solved! Go to Solution.
You might considering unpivoting all of the columns except the first.
You might considering unpivoting all of the columns except the first.
Awesome! 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |