DAX help for calculation from multiple tables

[kjani]

Here are my 3 inputs and desired output. Can you help?

[nandic · Accepted solution]

@kjani ,

First you need relationships between tables.
Example:



Select Usage table and add new column:

Output expected = RELATED(Rates[Rate])*Usage[Usage]

[Greg_Deckler]

@kjani - Do you have relationships between the tables? Please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[kjani]

Hello, please find attached additional details along with sample files in CSV.

Relationships:

Rates to Parts_lookup (One to Many using SAP ID)

Parts_lookup to Usage (One to Many using Part ID)

I need to calculate cost for each item (usage table). Each item has multiple parts (part id). Each part has a corresponding SAP id (many parts can have same SAP ID). I have shared 3 sample inputs. Desired output is $30, $66 and $105 respectively for each of the three items.