Forum Discussion
Divide two columns from two different tables using a filter
Sample data in a form that can be copied and pasted is always helpful. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, I'm thinking something along the lines of:
Measure = DIVIDE(SUMX(RELATEDTABLE('Sold ending 26th August'),[Quantity]),SUMX(RELATEDTABLE('Dispatched'),[Quantity Dispatched]))
Sample data in a form that can be copied and pasted is always helpful. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
That being said, I'm thinking something along the lines of:
Measure = DIVIDE(SUMX(RELATEDTABLE('Sold ending 26th August'),[Quantity]),SUMX(RELATEDTABLE('Dispatched'),[Quantity Dispatched]))