Row Subtotal not equal to sum of cells

[Harry_Tran]

Hi,

I have a data model like this

The column A, B, C from table location have values either 1 or 0.

I created a matrix with "SubCat_ID" as column and Sum A, B, C as Values

The issue that I have is 

The row subtotal ( as highlighted in orange) not equal to sum of all rows.

What I try to get is the Expected Total.

Thank you

[ppm1 · Accepted solution]

Please see this video - (2) Power BI - Tales from the front #01 - Getting the Right Total - YouTube

Pat

[Harry_Tran]

It worked. Thank you!