cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Keelin Regular Visitor
Regular Visitor

Sum Aggregate

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. 

 

TermFacultySchoolCourse codeHeadcountResponded
S2 2017lawlawLAW1232424
S2 2017lawlawLAW1242311
S2 2017lawlawLAW1252612
S2 2017lawlawLAW1263614
S2 2017lawlawLAW1275624
S2 2017lawlawLAW1282413
S2 2017lawlawLAW1294525

 

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Sum Aggregate

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

Keelin Regular Visitor
Regular Visitor

Re: Sum Aggregate

Thank-you Smiley Happy

2 REPLIES 2
Super User
Super User

Re: Sum Aggregate

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

Keelin Regular Visitor
Regular Visitor

Re: Sum Aggregate

Thank-you Smiley Happy