Measure for multiplying values from different tables

[rodfernandez]

Hi,

Have the followinfg tables 

Job	Type	Hours
Boss	A	2
Boss	B	1
Boss	C	2
Analyst	A	3
Analyst	B	5
Senior	A	2
Senior	B	2
Senior	C	2
manager	A	1
manager	B	2
assistant manager	A	1
assistant manager	C	3
assistant manager	D	6

Job	Money
Boss	10
Senior	5
Analyst	2
Secretary	1
Manager	8
Assistant Manager	7

And I want ot create the following graph 

Hours only sum the hours for each job ( only Boss, Analist and Senior) and money multiply the sum of hours with the respective money amount for each job 

I upload the to tables to power BI and related the two tables with the Job columns. I created this measure for the Money columns but it dosent work properly 

Amount Money (USD) =  
CALCULATE(SUM(Table1[Hours])*SUM(Table2[Money]))

[v-yuta-msft · Accepted solution]

@rodfernandez, 

Firstly, click query editor-> Merge Queries as New, do click the Fuzzy Match option.

 

After merged the table will be like below, then applied&close.

 

Create a measure using DAX below and drag Job, Hours and measure in the cluster column chart.

 

You can also refer to the appendix.

Community Support Team _ Jimmy Tao

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