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?
Currently there are no comments in this discussion, be the first to comment!