Forum Discussion

Garbo62's avatar
Garbo62
Resolver I
3 years ago

Power BI Matrix column not Summing

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 ro...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

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