Forum Discussion

reynaldo_malave's avatar
reynaldo_malave
Icon for Helper III rankHelper III
5 years ago

Sumx column total

Hi Guys,    I am trying to move a calculation from a sql query to dax. I am able to calculate the number on a row level but i cannot get a total from it. Here is my Dax:  Costo Oportunidad = v...
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

reynaldo_malave 

Can you try this modified version?

Costo Oportunidad =
VAR ventateorica7dias =
    SUMX (
        Desabasto,
        ( DIVIDE ( SUM ( Desabasto[Vtas30Días] ), 30 ) - Desabasto[Existencias] )
            * LOOKUPVALUE (
                Productos[Precio Venta],
                Productos[Código Producto], Desabasto[Producto]
            )
    )
RETURN
    ventateorica7dias
reynaldo_malave's avatar
reynaldo_malave
Icon for Helper III rankHelper III
5 years ago

HI Fowmy ,

Thanks for your answer, although new version aggregates shows a wrong total.