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.
Hello,
I am new to DAX and Power BI so please bare with me!
I am working with a report that contains many customer survey feedback responses for employees. Each employee is ranked on a score of 1 to 10. The scores are totalled up at the end of each quarter. I'd to create a column that calculates the total score for each employee per Q.
Here is an example that I created in excel. "Employee Total Per Q" is the extra column I would like to create
I looked at the CALCULATE function but that seems to require a specific value to be inputted like "Q3". Is this too complicated for a new column? Is there a better way to do this?
Thanks!
Solved! Go to Solution.
in calculated column, use this code
=calculate(sum(table[survey score]),allexcept(table,table[employee],table[Q+Year]))
Thank you @wdx223_Daniel!
Your solution worked, I'm not sure I understand exactly why but thank you all the same! 😉
in calculated column, use this code
=calculate(sum(table[survey score]),allexcept(table,table[employee],table[Q+Year]))
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 |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |