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.
@Anonymous
You can do the conversion with a measure like this.
Amount USD =
SUMX ('Table', 'Table'[Amount] * IF ( 'Table'[Currency] = "HKD", 7.8, 1 ) )
@Anonymous
You can do the conversion with a measure like this.
Amount USD =
SUMX ('Table', 'Table'[Amount] * IF ( 'Table'[Currency] = "HKD", 7.8, 1 ) )
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
