Subtotal with with max and sumx

[arielacosta_ar]

I can´t get the right subtotal when using MAX as you can see below. 

I need that TOTAL VENTAS adds one time the value of each row. i try using this:

Measure = CALCULATE(SUMX(GVA12;[MAX IMPORTE VENTAS]);VALUES(GVA12[CPTE VENTAS]);FILTER(GVA12;GVA12[T_COMP]<>"REC"))

but the result is the same that using TOTAL VENTAS.

The expected subtotal is -526.560,04

i´ll appreciate your help

Thanks

[v-yuezhe-msft]

@arielacosta_ar,

Would you please share raw data of your table and post the formula you use to create the MAX IMPORTE VENTAS measure?

Regards,
Lydia

[Greg_Deckler]

Probably has something to do with this issue:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376