Measure Multiplicate a value with a percentage

[Kibba664]

Hi all,

I would like to create a measure that allows me to multiply a column with monetary values ​​by another column with percentages.

Each row has its own percentage so if I do SUM(Table(Sales amount)* SUM(Table(Percentage) the result doesn't match the value I'm trying to get because it adds the percentages and doesn't multiply them row by row

here bellow a screenshot of what I'm looking for, and another of what I actually have with the DAX I've made

Thanks for your help 

[Kibba664]

Awesome, thanks for your help !

[Anonymous · Accepted solution]

Hello you are ylusing the sum function which will sum up all the percentage and multiple , to achieve what you want, use sumx

Sumx(table, [sum measure] * table[percentage])