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.)
A . Format the column to display zero decimal places.
B . Hide the column from client tools.
C . Create a measure named Sales based on the column by using the Data Analysis Expressions (DAX) SUM () function.
D . Rename the column to Sales.
E . Format the measure to display zero decimal places.
Answer: A, C
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.
* SUMX Function
Returns the sum of an expression evaluated for each row in a table.
Leave a Reply