Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
bhanunadendla
Frequent Visitor

Issue with group by option in Transform Data/Edit query settings

Issue with group by option in Transform Data/Edit query settings.

When i use this option, I get to choose between Count Distinct rows vs Count Rows. 

For some reason both these otpions giving same result. For some reason Count distinct is not wokring as expected.

 

As an alternate, I use New table to create Aggregate with count distinct but that won't allow to merge with any exiting tables as it won't show up in merge option.

2 REPLIES 2
amitchandak
Super User
Super User

@bhanunadendla ,Just check you are not doing count distinct on the unique column. If all values are unique then it will be same.  Share more information(Step you done) and data to test.

The unique identifier fort hat table is say combination of column A, B and C

when i want to do grouping, I am using count distinct column A along other columns like X and Z bcasue column A alone is not distinct.

In group by feature you ahve both distcint and regualr counts  but both gave me same result. 

 

I follwed workaround by using Table creation instaed group by which increased my development time. I wish this feature works as expectd.

 

thank you,

Bhanu

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.