topic Re: DAX: Total price from two tables in DAX Commands and Tips

DAX: Total price from two tables

Salauat — Wed, 02 Dec 2020 06:40:49 GMT

Hello, I have two tables.

In first table I have multiple Man.Model repeated N times.

In second table I also have Man.Model, but repeated once.

Product table:

Unit Price table:

I am trying to create New Measure, which will be counting Total Price = Product[Count_of Man.Model] * Unit Price[Unit Price]

I have placed simple Table visual in my report with filter by Date expire and I need above Measure to be recalculated every time, when filter changes

amitchandak — Wed, 02 Dec 2020 11:59:06 GMT

Salauat , if there is one to many relation then you can try like

Total Price =sum( Product[Count_of Man.Model] )* maxx(Product, related(Unit Price[Unit Price]))

else refer these ways to copy value from one table to another : https://www.youtube.com/watch?v=czNHt7UXIe8

Salauat — Thu, 03 Dec 2020 05:16:14 GMT

Thank you, the correct formula that worked for me is below:

Total = SUM(Product[Count_of Man.Model] )* counta(Product, related(Unit Price[Unit Price]))

Salauat — Thu, 03 Dec 2020 09:26:20 GMT

amitchandak Seems the formula you provided is not calculating the total correctly.

It multiplies Count * Unit_Price, but the overall rows total is not correct, it's way too huge