DAX calculations for converting currencies to USD is not working??

[shantanu97]

I write a simple dax column for converting GBP,AUD to USD. Final Currency in AUD.

Value USD = SWITCH(Related('OLAP Organisation'[BaseCurrency]),

"USD",'OLAP CUBE_Finance_WB'[Amount],

"GBP",'OLAP CUBE_Finance_WB'[Amount]*RELATED('Exchange Rates'[Rate to GBP/USD]),

"AUD",'OLAP CUBE_Finance_WB'[Amount]*RELATED('Exchange Rates'[Rate to AUD/USD])

)

There is no error in DAX Calculations but when I put in a table it is showing nothing???

@Anonymous 

Attach .pbix file: https://drive.google.com/file/d/1-mVUaShQaulAEtJpfy3RID_QBUar-y2F/view?usp=sharing

[amitchandak]

@shantanu97 , related is not working across two tables(A-B-C). I checked it using direct join between two tables by creating a date in 'OLAP CUBE_Finance_WB' and it worked

[shantanu97]

@amitchandak I didnot understand. Can you send me the file so I can understand better?

[amitchandak]

@shantanu97 , You are joining to date table and from date to rate table. Seem like related is limited to only one table. 

[shantanu97]

@amitchandak I didn't understand. Can you elaborate more on that???

I try to do this but it is not working. It will give error.

[amitchandak · Accepted solution]

@shantanu97 , please find the file after signature