Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Total or sum duplicates values

Hi all,

 

I need your assistance as I don't kwno what could be wrong.

I have a table with invoice data, but when I try to add a total to the column "Moneda Local" (Local currency) the total duplicates the value.

 

This is the base information

"Moneda local" (Local Currency) is a simple calculation of "Valor Neto" (Net value) * "Tipo de Cambio" (Exchange rate)

 

 

This is the same information but I select "SUM" in the drop down option list of the field "Moneda Local" to add a total

 

 

This also happens when I add the field "Moneda Local" to a separated card

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous , Multiplication should always be  done at row level

     

    likes

     

    sumx(sales, sales[Qty] * related(item[price])

     

    or

     

    sumx(Values(Item[Item]), calculate(Sum(Sales[Qty]) * Average(Po[Price]) ) )

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      What if I made that multiplicatión in Power Query? Will this be ok or making a "New Measure" will be a better option?