Group By fx in PBI Power Query does not group all duplicates as with Excel Power Query.

[jzadok]

All - I have been doing some research on a Group By issue and have yet to find a solution...In Power BI, when performing the Group By function, I find that not all the duplicate values are uniquely grouped with corrsponding counts as they do in Power Query (Excel). My thinking is that performing the same function with the same data would produce the same result in both PBI and Excel. 

Curious if anyone here has ever run into this scenario and knows of a solution in PBI that will provide the expected outcome. 

Any help here would be greatly appreciated.