Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft DP-600 Exam - Topic 3 Question 57 Discussion

You are designing a Fabric semantic model named Model! for a financial analytics workspace. Modell includes a DAX measure named Measure1 that returns total sales.You have a table named Currency that contains a column named Format. The Format column defines currency formatting strings for each record as follows: $8,880.00, ta,880.00, or yv.sve.ee.You have a report that uses the Currency column to identify which symbol and format string to display. In the report Measure1 must appear with two decimal places and the appropriate currency symbol based on the selected value in the Currency column.You create the following DAX formula.FORMAT = SELECTEDVALUE('Currency'[Format])You need to ensure that Measure1 appears correctly in visuals. The solution must minimize logic duplication. What should you do?
A) Create a dynamic format string for Measure1 that references the FORMAT measure.
B) For Modell, set the data category of Measure to Country/Region.
C) For Modell, set the format type of Measure1 to Currency.
D) Copy the DAX expression from the Format column and profile the expression into the format string expression of Measure.

Microsoft DP-600 Exam - Topic 3 Question 57 Discussion

Actual exam question for Microsoft's DP-600 exam
Question #: 57
Topic #: 3
[All DP-600 Questions]

You are designing a Fabric semantic model named Model! for a financial analytics workspace. Modell includes a DAX measure named Measure1 that returns total sales.

You have a table named Currency that contains a column named Format. The Format column defines currency formatting strings for each record as follows: $8,880.00, ta,880.00, or yv.sve.ee.

You have a report that uses the Currency column to identify which symbol and format string to display. In the report Measure1 must appear with two decimal places and the appropriate currency symbol based on the selected value in the Currency column.

You create the following DAX formula.

FORMAT = SELECTEDVALUE('Currency'[Format])

You need to ensure that Measure1 appears correctly in visuals. The solution must minimize logic duplication. What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: A

Contribute your Thoughts:

0/2000 characters

Currently there are no comments in this discussion, be the first to comment!


Save Cancel