Distinct Count Measure in PowerPivot using DAX
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…”