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

 

 

Need Help

3 Replies

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

  • Garbo62's avatar
    Garbo62
    Resolver I
    3 years ago

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

    ((CourseDetails[UnitTotalHours]/[Week])*[Ratio])
  • Garbo62's avatar
    Garbo62
    Resolver I
    3 years ago

    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.