Power BI Matrix column not Summing

[Garbo62]

Hi

I have a powe BI Matric that is showing in the Column Total an incorrect value

In the screen shot you see there are 5 values of 12.4 so the colum total should be 62, but it shows as 12.4

The row totals are correct

The values is a measure not a set number in a table

Any Ideas why it is  not adding up the totals correctly?

The measure is:

Hours max per Course - Week =

MAXX(

    KEEPFILTERS(VALUES('WeeklyBreakdown'[Course - Week])),

    CALCULATE(SUM('CourseDetails'[Hours]))

)

[Garbo62]

Hi,  tried both options but the total is still not totalling

Why would the total not want so sum the values in the Matrix?

The total at the bottom are correct.

[Garbo62]

Hi Thanks but Sorrry I has cut the code from yhe adjoinmg colum the column in question is

((CourseDetails[UnitTotalHours]/[Week])*[Ratio])

[amitchandak]

@Garbo62 , Use SUMX

Hours max per Course - Week =
SUMX(
(VALUES('WeeklyBreakdown'[Course - Week])),
CALCULATE(SUM('CourseDetails'[Hours]))
)

or

SUMX(
KEEPFILTERS(VALUES('WeeklyBreakdown'[Course - Week])),
CALCULATE(SUM('CourseDetails'[Hours]))
)