Matrix Visual Total Row

Hi harmishPatel ,

Thanks for Greg_Deckler 's reply!

And harmishPatel , The format of having multiple rows of Total in the middle of the matrix like this is not supported in the Matrix visual object in Power BI Desktop,

the most you can achieve is to display the value of Total on the parent node like you have already implemented.

Also in the screenshot you provided on your side it seems that the total for Case Count is correct and the totals for the other two columns are wrong, you can try to create these two additional measures:

Total Hours Worked = SUMX(VALUES('Table'[Case id]), [Total Hours Worked])

Peer Hours Worked = SUMX(VALUES('Table'[Case id]), [Peer Hours Worked])

Change the measures put in the last two columns of the matrix to these two measures and check Total again to see if it is correct.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.