Divide two columns from two different tables using a filter

[WillEyedowin]

Hi All,

I am trying to divide two columns from two different tables and use a common filter in a third table.

The common column or filter is the Store Name.

The two data columns which I would like to use for the calculation are Sold ending 26th August[Quantity Sold] and Dispatched[Quantity Dispatched].

I would like to divide the sum of  Sold ending 26th August[Quantity Sold](B) for a Stores[Store Name](C) by the sum of  Dispatched[Quantity Dispatched](A)

I have tried using Related() and RelatedTable() and a few other options but I am stuck.

Dispatched table where example A data is found:

 

Sold ending 26th August Table where B sample data is found

Stores table - where C sample data is found - I want to use this to filter the other 2 tables

This is essentially how I want this report to work- Divide the first column by the second and another column stores the result.

 

How the relationships are currently set up

Tables and the columns used

Also, let me know if any more information is needed as I am new to these forums and rather new to PowerBI.

Any help would be greatly appreciated.

[Greg_Deckler · Accepted solution]

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