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 All,
I am at a total loss.
I have a dataset and all I want to do is aggregate and sum a column and I cannot get it right.
Term | Faculty | School | Course code | Headcount | Responded |
S2 2017 | law | law | LAW123 | 24 | 24 |
S2 2017 | law | law | LAW124 | 23 | 11 |
S2 2017 | law | law | LAW125 | 26 | 12 |
S2 2017 | law | law | LAW126 | 36 | 14 |
S2 2017 | law | law | LAW127 | 56 | 24 |
S2 2017 | law | law | LAW128 | 24 | 13 |
S2 2017 | law | law | LAW129 | 45 | 25 |
All I want to do is aggregate the values for headcount for the faculty of Law for S2 2017. The correct figure is about 7,000 and when I just use a simple graph in power bi the figure comes out at over 50k.
It is a big dataset with a lot of different faculties, terms, courses and schools. So I am guessing I need to use an All except measure? I cannot figure this out.
Many thanks,
(from someone extremely tired!)
Solved! Go to Solution.
What does CALCULATE(SUM[Headcount],[Faculty]="law", [Term]="S2 2017") give you?
What does CALCULATE(SUM[Headcount],[Faculty]="law", [Term]="S2 2017") give you?
Thank-you 🙂
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |