Cumulative frequency percentage over two or more Tables in Power BI

[SteelChampzz]

I've been trying to find the right way to explain the issue that I'm having:

I have 2 Tables- "Fruit-Ordered" & "Fruit-Sold"

I've created a measure that puts both tables together in power bi

example:

In the "Total" Columns I've create "Cumulative Frequency Percentage" from excel.

Now I want to create a measure of "Cumulative Frequency Percentage" in Power BI, between the two tables I have.

Is this possible to create a measure from the TWO tables 

or

Do I need to create a "custom" table between the two.

I really hope I find the right answer for this, and thanks to anyone for the help

[vanessafvg · Accepted solution]

if you want to not join the tables into one you will need to create a table of unique values of the product between the tables and then join the product (or fruit) in each transactional table to this middle table.  then you can have a join between the tables and easily aggregate both values against the product.  If you have a dates you will need to do the same with adding a date table in the middle of the 2 transactional tables.

[SteelChampzz]

Thank you for responding to this!
It seems like a long process to do it this way but I totally understand

[vanessafvg]

yep correct, modelling your data correctly while it may take a bit longer to set up (although there are ways and means to speeding this up) will make your life far easier in the long terrm however it just depends on what you need the model for.  For a quick answer to a model that is only required for adhoc analysis then just do a merge table in power query using a full outer join.

[SteelChampzz]

The data I used in the example was just a mock of what data I'm actually using.
There alot of "extra" step when it comes to cleaning the data in power query.
Thank you for the help and understanding when it comes to dealing with this issue