Sum Aggregate

[Anonymous]

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!)

[jthomson · Accepted solution]

What does CALCULATE(SUM[Headcount],[Faculty]="law", [Term]="S2 2017") give you?

[jthomson · Accepted solution]

What does CALCULATE(SUM[Headcount],[Faculty]="law", [Term]="S2 2017") give you?

[Anonymous · Accepted solution]

Thank-you 🙂