Forum Discussion
PowerBI Running Total error
Hi scd66 ,
you are summing the individual columns then doing the product. Instead you could put all the columns in the same table, then use this formula:
Measure = SUMX(Table, Column1 * (Column2/100) * (Column3/100))
Hope this helps, do give a kudos if it solves your problem 🙂Thank you so much Samantha. I got your formula to work when I merged the area table to the percentages table and it now gives the correct running total.
Hi scd66 ,
you are summing the individual columns then doing the product. Instead you could put all the columns in the same table, then use this formula:
Measure = SUMX(Table, Column1 * (Column2/100) * (Column3/100))
Hope this helps, do give a kudos if it solves your problem 🙂
Thank you so much Samantha. I got your formula to work when I merged the area table to the percentages table and it now gives the correct running total.