Multiply two tables

[OSS]

Dear all

I have two tables. First table contains account numbers and amount columns.

The second table also contains account numbers and division percentages.

I need to connect these tables via account number. Then I need to divide amount in the first table by multplying with A1, A2 and A3 in the second table.

More exactly, if A1, A2, A3 is 25%, 15% and 59% for the first account number respectively, I need to multiply these indicators with my amount column and get 3 different columns which total sum would be 183.33.

I have created measure in the first table. The result also shown below. Everyting is seen ok, except the total values. I cannot solve the problem related to the sum.

Despite my second table consists from unique account numbers connection between the first and the second tables gives me many to may result. How can I fix this problem?

Is my first question (total value problem) related to this connection type?

. 

[v-jiascu-msft]

Hi @OSS,

Could you please mark the proper answers as solutions?

Best Regards,

[OSS · Accepted solution]

How I have solved the problem:

First I have unpivoted the second table with percentages. Then muptiply with the previous table.

[Greg_Deckler]

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907