Using multiplication expression

[Anonymous]

I need to create a measure that the value of two fields will have to be multiplied, I made the following measure:

Purchase Order = sum (Facts [Vl_PedidoCompra]) * SUM (Facts [Qtd_PedidoCompra])

this form is coming more than double the correct value, I tried to create the measure

Purchase Order =SUM (Facts [Vl_PedidoCompra] * Facts [Qtd_PedidoCompra])

however the power does not allow bi, also tried

Purchase Order = (Facts [Vl_PedidoCompra] * Facts [Qtd_PedidoCompra])

  however the power bi requires an aggregator is used

[Sean · Accepted solution]

@Anonymous

Purchase Order = SUMX(Facts, Facts[VI_PedidoCompra]*Facts[Qtd_PedidoCompra])