Fixed rate currency conversion to display on matrix

[Anonymous]

Hi guys,

I am just a newbie in Power BI and I have encountered some difficulties.

One of the difficulties are I have to covert HKD to USD with a fixed rate of 7.8 and add the originally HKD values and USD values together in USD as the total amount in a matrix visual. What my supervisor wants is the matrix only show USD values of both transactions done in HKD and USD, and also the total amount of transactions in USD.

Thank you very much for your assistance.

[jdbuchanan71 · Accepted solution]

@Anonymous 

You can do the conversion with a measure like this.

Amount USD = 
SUMX ('Table', 'Table'[Amount] * IF ( 'Table'[Currency] = "HKD", 7.8, 1 ) )