Which of the following is true of a measure in Power Pivot?
A)A measure can be used to fill a column in a table of a Data Model.
B)A measure is always a summarization by summing.
C)Measures are basically the same as calculated fields,which have been available for Excel pivot tables for many years,so they don't add much new functionality.
D)Measures created by DAX are always listed in the PivotTable Fields pane,so that they can be used just like any other fields in the Values area of a pivot table.

Question

Quizplus · Accepted Answer

Measures in Power Pivot are created using Data Analysis Expressions (DAX) and are designed to be used in PivotTables or PivotCharts. They are not limited to summing but can perform a variety of aggregations or calculations. Unlike calculated columns, measures do not fill a column in a table; instead, they perform calculations on the fly based on the data currently being viewed in a PivotTable or PivotChart. Measures offer advanced functionality beyond traditional calculated fields in Excel pivot tables, making them a powerful tool for data analysis. They are indeed listed in the PivotTable Fields pane and can be used in the Values area of a PivotTable, allowing for dynamic and complex data analysis.

Which of the Following Is True of a Measure in Power