nerdexam
Microsoft

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…

Create business solutions

Question

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 have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. A company has locations in multiple countries and regions across four continents. The company stores the total amount of each order in the local currency of the country/region where the customer is located. The company stores the applicable exchange rates in a custom US dollars (USD) exchange rate table. You need to create a visualization that displays the total amount of orders by country/region in USD. Proposed solution: Create a custom calculated field of type currency on the order table that converts the order total to USD and displays the total amounts by region in a Power BI chart. Does the solution meet the goal?

Options

  • AYes
  • BNo

How the community answered

(31 responses)
  • A
    84% (26)
  • B
    16% (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

#Calculated Fields#Currency Conversion#Power BI#Dataverse

Community Discussion

No community discussion yet for this question.

Full PL-100 Practice