Forum Discussion
Measure for multiplying values from different tables
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]))
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.
1 Reply
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.