New Group By aggregate function - count distinct values
Important
This content is archived and is not being updated. For the latest documentation, go to Integrate data into Microsoft Dataverse. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.
| Enabled for | Public preview | General availability |
|---|---|---|
| Admins, makers, marketers, or analysts, automatically | - | 
Jan 14, 2022 |
Business value
Makers will have the ability to count the number of distinct values within a group.
Feature details
When grouping rows, makers currently have the ability to count the total number of values within each group; however, one of the most frequently asked-for capabilities is the power to count the number of distinct values. We're adding this capability as an aggregate function in the Group By transform.
See also
Grouping or summarizing rows (docs)