cancel
Showing results for
Did you mean:
Helper III

Multiply two tables

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?

1 ACCEPTED SOLUTION
Helper III

How I have solved the problem:

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

3 REPLIES 3
Microsoft

Hi @OSS,

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper III

How I have solved the problem:

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

Super User

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

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...