Sumar Columna resultado de una medida.

[sanvass72]

Hola: les comento que tengo una tabla donde obtengo una columna  IMPORTE (medida), otra columna FACTURACION SIMULADA ANTERIOR (medida) y otra columna IMPACTO MIX (medida) que es la diferencia entre las 2 anteriores.

El problema es que no se como mostrar los totales sumando los valores la columna.

[v-zhangti · Accepted solution]

Hi, @sanvass72 

I've simulated some data that I hope fits your situation. The function IF(HASONEVALUE()), can control the output of Total.

Difference = 
IF (
    HASONEVALUE ( 'Table'[Date] ),
    [Previous Amount] - [Amount],
    SUMX (
        SUMMARIZE ( 'Table', 'Table'[Date], "Difference", [Previous Amount] - [Amount] ),
        [Difference]
    )
)

You can try this formula and see if it outputs the results you expect. If it still does not work out, please provide more example data.

Best Regards,

Community Support Team _Charlotte

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