Distribution of actual sales by total target sales

[ThuJa23]

Hi all, 

I have 2 tables

Table 1 is sale information by region and items

Table 2 is total target sales by items

I would like to calculate by using DAX measure, the distribution of each item in each region vs. total target sales of each item. Both table have same filter of year and month. The result should be as below

In Excel I used Vlookup to look up the value from table 2 to display total target sales for each row of table 1. 

How can we use DAX measure in this case? As our data is store as multidimension cube, so I just can use only DAX Measure, and cannot calculated column. 

Thanks for your helps so much!

Thu

[tt_and]

Edit: I'm so sorry, I overlooked that you can't edit the model. Can you show us how the tables are related in the model?

There's several ways to do this. I'll show you by making a star schema model:

Make dimension tables for attrbutes, in this case Region and Item (unique values) and relate them:

Then make this measure:

% distribution = divide(sum(SalesByRegion[Sales]),sum(SalesByItem[Target sales]))

Drag columns to table visual:

[ThuJa23]

Hi @tt_and , 

Above is my quick basic example, but under is the current model between the tables of real data

relationship between Table 1 and FAC Table

Relationship between Table 2 and FAC table

Do you have ideas how to help me?

Thanks so much

Thu

[tt_and]

Edit: Wait, where is your second fact table?

Ok, you actually have the same structure in your model and should be able to use the simpel dax with DIVIDE if you build the visual table as in my example