Totals not adding up

[smedina_25]

Hi All I made a repport that has row and column subtotals and the row (althoug PBI says is column) totals are not adding up. Here is the measure that I did for the calculation of totals:

m_Total = var _table = SUMMARIZE(Query1,Query1[Major],"_value",[m_Single]) return IF(HASONEVALUE(Query1[Major]),[m_Single],SUMX(_table,[_value]))

[v-yulgu-msft]

Hi @smedina_25 ,

I tested with simple dataset, both column total and row total add up values correctly.

For the unexpected result, it might be related to your source dataset. Please provide sample data of 'Query1', other linked tables if existing and the formula of [m_Single]. How to Get Your Question Answered Quickly

Best regards,

Yuliana Gu

[smedina_25]

Thanks! I'll try to get the data, in the meantime, I forgot to mention that the table on the screenshot was filtered data, without the filters the totals are ok.

[v-yulgu-msft]

Hi @smedina_25 ,

Please show sample data in source table 'Query1' and how you filter the matrix.

Regards,

Yuliana Gu