Count of Unique Values DistinctCount in Power BI Through Power Query Group By Transformation

You can have a distinct count calculation in multiple places in Power BI, through DAX code, using the Visual's aggregation on a field, or even in Power Query. If you are doing the distinct count in Power Query as part of a group by operation, however, the existing distinct count is for all columns in the table, not for a particular column. In this video, I'll show you a method you can use to get the distinct count of a particular column through the Group By transformation in Power Query component of Power BI.
Download the sample file from my blog article here:
https://radacad.com/count-of-unique-values-distinctcount-in-power-bi-through-power-query-group-by-transformation
*******************

Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.

RADACAD courses: https://learn.radacad.com

Become an academy member: https://learn.radacad.com/product-category/membership/

*******************

********
CONNECT with US!
********

-- http://twitter.com/radacad_com
-- http://twitter.com/rad_reza
-- http://twitter.com/leila_etaati
-- http://www.facebook.com/radacad
-- https://www.linkedin.com/company/6393399
-- https://radacad.com

********

Видео Count of Unique Values DistinctCount in Power BI Through Power Query Group By Transformation канала RADACAD