Sum of values in column from measure

[Anonymous]

I've seen feedback on this issue elsewhere but haven't as yet been able to apply any fixes to my own measure.

I have the following measure for which I want the total to show the sum of the rows in the table rather than applying the measure to the total:

Count of Applications = 

VAR CurrentYear = [CurrentYearOfEntry] - 2

RETURN

CALCULATE(

DISTINCTCOUNT(

CourseApplication[StudentCode]),

CourseApplication[Flag] = "1",

CurrentYear = CourseApplication[YearOfEntry],

CourseApplication[Group] = "Cohort1"

)

Currently this gives the result of:

CourseName	Count of Applications
Engineering1	8
Engineering2	1
Engineering3	2
Engineering4	2
Total	12

I would need the total column to be the sum of the rows, so be 13 rather than 12 - how can amend my measure to allow for this?

Thanks for any help!

[amitchandak · Accepted solution]

@Anonymous , try like

Count of Applications = 

VAR CurrentYear = [CurrentYearOfEntry] - 2
RETURN
Sumx(Values(CourseApplication [CourseName]) CALCULATE(
DISTINCTCOUNT(
CourseApplication[StudentCode]),filter(CourseApplication,
CourseApplication[Flag] = "1",
CurrentYear = CourseApplication[YearOfEntry],
CourseApplication[Group] = "Cohort1"
)))

[Anonymous]

Thanks @amitchandak that works great.  I had just come up with the following solution which also worked:

Count of Applications = 

VAR CurrentYear = [CurrentYearOfEntry] - 2
RETURN
IF( ISFILTERED ( CourseApplication [CourseMode]),

Sumx(CourseApplication, CALCULATE(
DISTINCTCOUNT(
CourseApplication[StudentCode]),filter(CourseApplication,
CourseApplication[Flag] = "1",
CurrentYear = CourseApplication[YearOfEntry],
CourseApplication[Group] = "Cohort1"
)))

But your solution seems much neater and works just as well.

Thanks so much!