Budget cost sliced by dimension displaying both USD and local$

[Anonymous]

Hi,

I have the data model from the sample dataset as described in the image.The relationship goes like below:

• Users to Usage-> 1..M
• USage to lookup->M..1
• Lookup to Budget->1..M

The real dataset contains ~6000 users and 10 more products.There is another table for currency conversion that states local curreny and exchange rates.Each product has a different condition- some are all employee and some are from specific sources.In the sample,i have presented only small sample.

I want to be able to show the local currency $ as well along with USDcost$ when sliced by Users dimension as presented in the expected output format.I am stuck for the local currency cost.I have 2 measures called :

HC=

CALCULATE(DISTINCTCOUNT('Usage'[User]))

USDCost=

CALCULATE(sum(Budget[UnitCost])*[HC],USERELATIONSHIP('Usage'[Product],Lookup[Product]))

Budget[UnitCost] column is calculated as 

DIVIDE(Budget[PerMonthCost$],[HC],BLANK())