How to sum table1 based on table2 values

leandrovieira 

Use lookup to get the price

Price = LOOKUPVALUE('dim'[Price],dim[Name],'fact'[Name])

 

Hi,

Create a relationship from the Name column of the Fact Table to the Name column of the Dim Table.  In the Fact Table, write this calculated column formula

Prices = related('Dimension table'[Price])

To your visual, drag Name from the Dimension Table and write this measure

Total = SUM('Dimension table'[Prices])

Hope this helps.