Total columns in matrix does not retun the SUM

[drivero]

Hi, 

I have this data but when I apply the subtotal column from Visual, the TOTAL is not working. Is showing just the last values from the last month, but it should be the sum of all months for the metric. Here you have:

[drivero]

some data:

IdCliente IdEstado FechaSolicitud Aceptado% ImporteSolicitado MotivoKO
201 5 2021-03-10 00:00:00.0000000 3000000 NULL NULL
5691 5 2021-06-01 00:00:00.0000000 250000 NULL NULL
87 5 2018-02-21 00:00:00.0000000 45000 NULL NULL
317 5 2019-11-22 00:00:00.0000000 12600 NULL NULL
320 5 2022-04-25 16:44:20.4248355 226000 NULL NULL
328 5 2021-01-29 00:00:00.0000000 30000 NULL NULL
769 5 2019-11-07 00:00:00.0000000 140000 NULL NULL
1180 5 2019-02-07 00:00:00.0000000 8000000 NULL NULL
5683 5 2021-04-05 00:00:00.0000000 50000 NULL NULL
5686 5 2019-10-10 00:00:00.0000000 0 NULL NULL
5709 5 2020-03-23 00:00:00.0000000 300000 NULL NULL
45 5 2021-04-26 00:00:00.0000000 0 NULL NULL
46 5 2021-04-26 00:00:00.0000000 0 NULL NULL
60 5 2020-03-31 00:00:00.0000000 NULL NULL NULL
81 5 2019-05-23 00:00:00.0000000 8000 NULL NULL
89 5 2022-04-25 16:44:21.6591717 NULL NULL NULL


and then I have the  'DWH DimDate' with diferents columns (calendar values, month, year, etc). I tried this:

var result = CALCULATE(count('DWH FacRiesgo_Otops'[Aceptado%]),
'DWH FacRiesgo_Otops'[Aceptado%] = 0.00,
'DWH FacRiesgo_Otops'[IdEstado] <> 14,
'DWH FacRiesgo_Otops'[IdEstado] <> 15,
'DWH FacRiesgo_Otops'[IdEstado] <> 12)

RETURN
Calculate ( sumx ( values ('DWH FacRiesgo_Otops'[Aceptado%]), result) )
--Calculate ( sumx ( values ('DWH DimDate'[Month]), result) )

[sevenhills]

[# Aceptado 0% 2] = Calculate ( sumx ( values (yourmatrixcol1), [# Aceptado 0%]) )

See if the above measure works, then you can tweak and combine both into one...

[# Aceptado 0%] =
var _mStep = ... your existing measure code ...
RETURN Calculate ( sumx ( values (yourmatrixcol1), _mStep) )

[drivero]

I tried both but still does not work 😞