Pivot Tables with One Measure Pivot Tables with One Measure To display measures as columns, you can drag and drop them to the Measures box or to the Columns box. If the pivot table has multiple measures, the resulting pivot table (and underlying MDX query) is identical with either technique. If the pivot table has only a single measure, however, the two techniques generate slightly different MDX queries: Technique Comments Drag and drop the measure to the Measures box The underlying MDX query uses the measure in its filter clause. This means that this pivot table cannot be displayed in a scorecard (on a dashboard). Drag and drop the measure to the Columns box The underlying MDX query uses the measure as a column. This pivot table can be displayed in a scorecard.
