DAX: Total price from two tables

[Salauat]

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:

• Device name
• Manufacturer model
• Date expire

Unit Price table:

• Manufacturer model
• Unit Price

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 · Accepted solution]

@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]

@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

[Salauat]

Hello @amitchandak !

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]))