Dividing colomns from different files

[Anonymous]

Dear,

I'm in desperate need of your help. 

I have 2 data-sets which have a relation with eachother. now i would like to have a visual with a line with shows the amount "lijnen gedaan picking" divided by "Uren picking" and same for packing. And the date being the X-axis but i cannot seem to get it to work. 

Your assistance is well appreciated!

[Anonymous · Accepted solution]

Dear all,

Looks like i got it to work myself, however i really appreciate the help. 

Solution was a simple meassurement which i did for all the 4 categories i did. Example:

Packing orders per uur = DIVIDE(SUM(Plakken[Orders Gedaan Packing]),SUM(Urenregistratie[Uren packing]))

[johnt75]

Try

Picking =
SUMX (
    'Plakken',
    DIVIDE (
        'Plakken'[lijnen gedaan picking],
        RELATED ( 'Urenregistratie'[Uren picking] )
    )
)

[Anonymous]

hi @johnt75 

First of all many thanks for your reply!

I did but i got the wrong values. I attached an example for what i'm looking for. Basically i need the following formula 
Picking = Lijnen gedaan picking / (Divided by) werkuren picking 

For the 5th of january the value should be 1030 / 112,50 = 9.155555....

Normally it should not be an issue to do this but given the 2 colomns are not in the same table it's causing issues. 

Hope you can help! Very much appreciated