Calculation using different tables with no relationship

@RavitPBI , Create two/three common dimension table date, org, and vendor. Accompany them with boards and then use it.

Refer to this video how two create one when they have one -https://www.youtube.com/watch?v=Bkf35Roman8

Provide your feedback and tips for new videos
Dax Series Tutorial Vs SQL Direct Query PBI Tips
We appreciate your congratulations.

Hi, RavitPBI 

It’s my pleasure to answer for you.

According to your description, I think you can create two slicers(column in table C) and a measure to calculate the desired result.

Like this:

HoursNeeded =
VAR dateid =
    SELECTEDVALUE ( GoalUPH[Date_id] )
VAR orgid =
    SELECTEDVALUE ( GoalUPH[Org_id] )
VAR sumunits =
    SUMX (
        FILTER ( ALL ( Outbound ), [Date_id] = dateid && [Org_id] = orgid ),
        [OutboundUnits]
    )
        + SUMX (
            FILTER ( ALL ( Inbound ), [Date_id] = dateid && [Org_id] = orgid ),
            [InboundUnits]
        )
RETURN
    IF (
        ISFILTERED ( GoalUPH[Date_id] ) && ISFILTERED ( GoalUPH[Org_id] ),
        DIVIDE ( sumunits, SELECTEDVALUE ( GoalUPH[GoalUPH] ) ),
        0
    )

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.