You need to ensure that the Sales measure in the Power View field list meets the requirements. What should you do? (Each correct answer presents a part of the solution. Choose all that apply.)

The correct answer is A. Format the column to display zero decimal places. C. Create a measure named Sales based on the column by using the Data Analysis Expressions. Data Analysis Expressions (DAX) provides many functions for creating aggregations such as sums, counts, and averages. These functions are very similar to aggregation functions used by Microsoft Excel. Returns the sum of an expression evaluated for each row in a table.

Design BI data models

Question

Options

AFormat the column to display zero decimal places.
BHide the column from client tools.
CCreate a measure named Sales based on the column by using the Data Analysis Expressions
DRename the column to Sales.
EFormat the measure to display zero decimal places.

How the community answered

(30 responses)

A
70% (21)
B
10% (3)
D
3% (1)
E
17% (5)

Explanation

Data Analysis Expressions (DAX) provides many functions for creating aggregations such as sums, counts, and averages. These functions are very similar to aggregation functions used by Microsoft Excel. Returns the sum of an expression evaluated for each row in a table.

Topics

#Power View field list#DAX measure#tabular model#column formatting

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice