The Data Model, which integrates Power Pivot Table with Excel, offers users powerful features. One of these includes the ability for Pivot Tables to calculate the distinct counts of unique values in Excel.