Column subtotals do not add up

[israelfc92]

Hello, I hope you can help me. I have a matrix made through measurements and two levels that does not fit in the subtotals by columns. I already squared the subtotals at the row level. I'm just missing this, thanks for the help.

Measure

Matrix

[israelfc92]

Thanks Daniel, so I solved it. Regards

[Daniel29195 · Accepted solution]

hello @israelfc92 ,

try changing your code to the following : 
calculate(
sumx(
values(ventas[ID EMPRESA]),
calculate(
sumx(
values(fechas[año-mes]),
round([measure]/ 10000, 0)
)
)
)
)

if you do not have a column in date table  "year-month", you can create it easily with a calculated column

let me know if this works for you.