Distinct Count Measure in PowerPivot using DAX

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active

A PivotTable based on PowerPivot data doesn’t offer a native Distinct Count aggregation. To calculate it, you need to create a calculated measure in the PivotTable. For example, if we have a simple Sales table from AdventureWorks loaded in PowerPivot and projected into a PivotTable like the following picture.

To create a new measure, we need to right-click on the field pane the menu “Add New Measure…”


Tags: dax, excel


2007-2015 VidasSoft Systems Inc.