Column Distribution in Power Query Editor

The column distribution in Power BI, shows us the distribution of the data within the column and the counts of distinct and unique values.

• “Distinct” means total number of different values regardless how many times it appears in the dataset. A name appears in the list multiple times is counted as 1 distinct count.
• Whereas the “Unique” value is total number of values that only appear once.