Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
@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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
79 | |
64 | |
52 | |
47 |
User | Count |
---|---|
216 | |
89 | |
76 | |
67 | |
60 |