Forum Discussion
Solved
PowerBI Running Total error
I am trying to multiply 3 columns together in a PowerBI Table Visual and this seems to work well for the row values and gives the correct answer, but it seems to produce a huge running total which is...
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.
Hello ,
You can try below measure
NIA Area Used2 =
SUMX(
Locations,
Locations[NIA sqm] *
RELATED(Merge Org Occ Usage[Percentage Org]) *
RELATED(Merge Org Occ Usage[Percent Usage Activity Tag])
)
if it is not helping share sample pbix