1.表

Country Currency Format String

Yearly Average Exchange Rates

2.度量值

計(jì)算年均匯率：以美元作為標(biāo)準(zhǔn)，匯率為1，其他國(guó)家/地區(qū)按各自的年均匯率

AVG RATE = 
IF( 
    ISBLANK(SELECTEDVALUE('Country Currency Format String'[Country]))
    || SELECTEDVALUE('Country Currency Format String'[Country])="United States",
    1,
    AVERAGE('Yearly Average Exchange Rates'[Yearly Average Exchange Rates])
)

對(duì)基礎(chǔ)度量進(jìn)行匯率換算

Converted Sales = [Sales Amount]*[AVG RATE]

3.設(shè)置動(dòng)態(tài)度量值

image.png

//選擇國(guó)家?guī)欧N格式，否則默認(rèn)展示美元符號(hào)
SELECTEDVALUE (
    'Country Currency Format String'[Format],
    "\$#,0.00;(\$#,0.00);\$#,0.00"
)

image.png