Total is not the sum of column in a table

[Anonymous]

Hi everyone, i have the following issue:

I have a matrix of measures as columns and the measure with the mistake is defined by this formula: ([Measure 1]/[Measure 2])*[Measure 3]. In every row i have the correct value but in the Total row, i need the sum of the column but not the calculated formula.

The measuere is TO_MIX. The Total 5942314.67 is wrong because is the calculated formula and not the sum of the column.

I appreciate your comments.

Regards.

Federico

[v-deddai1-msft · Accepted solution]

Hi @Anonymous .

Would you please try the following measure:

To_Mix =
SUMX ( VALUES ( 'Jerarquia APH'[Prod] ), [TO_C1] / [TON_C1] * [Ton_Mix] )

If it doesn't work, please show us sample pbix for accurate formula. And you can also refer to https://www.burningsuit.co.uk/blog/2018/07/dax-is-the-total-row-in-a-table-giving-you-grief/ for total issue in table visual.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[amitchandak]

@Anonymous , Change you calculation like

Sumx(values(Table[Product]), <Your current formula>)

[Anonymous]

Do you mean like this?

It still doesn´t work.