topic Re: Measure Multiplicate a value with a percentage in DAX Commands and Tips

Measure Multiplicate a value with a percentage

Kibba664 — Sun, 05 Feb 2023 14:39:28 GMT

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

Re: Measure Multiplicate a value with a percentage

Anonymous — Sun, 05 Feb 2023 14:47:15 GMT

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])

Re: Measure Multiplicate a value with a percentage

Kibba664 — Sun, 05 Feb 2023 15:01:37 GMT

Awesome, thanks for your help !