Forum Discussion
Solved
Divide two columns
Hi all, I could not find the right formula for the below, can someone please assist: I have two columns in one dataset, the one column is sales and the other is product quantity. The sales co...
Hi all,
I solved the incorrect totals by creating a calculated column and not a measure.
Thanks!
V-lianl-msft
Community Support
Community SupportHi John_V12 ,
Try to create a measure like below:
Measure = DIVIDE(SUM('Table'[Sales]),SUM('Table'[Quantity]))
If the problem persists, please share some sample data and the results you expect.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.