PL-100 · Question #68
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might…
The correct answer is A. Yes. The answer is Yes. This variant correctly solves the multi-currency USD visualization requirement. The proposed solution likely uses a DAX measure with SUMX to iterate over the orders table, look up the corresponding exchange rate for each order's country/region from the…
Question
Options
- AYes
- BNo
How the community answered
(31 responses)- A84% (26)
- B16% (5)
Explanation
The answer is Yes. This variant correctly solves the multi-currency USD visualization requirement. The proposed solution likely uses a DAX measure with SUMX to iterate over the orders table, look up the corresponding exchange rate for each order's country/region from the exchange rate table, multiply the local currency amount by that rate, and sum the results. For example: TotalUSD = SUMX(Orders, Orders[OrderAmount] * RELATED(ExchangeRates[Rate])). This approach correctly handles the row-by-row conversion using the related exchange rate table and produces an accurate aggregate USD total that can be displayed in a Power BI visualization filtered by region or country.
Topics
Community Discussion
No community discussion yet for this question.