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.
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.
(from someone extremely tired!)
Solved! Go to Solution.