Need display duplicate data

[RD_PowerBI31]

Hello,

I have data like this. The below records are not a duplicate. My requiremnt is if I remove the Code column I should see same number of records, it should not remove the duplicates (after removing the code column records will be duplicate right).

NAME	DEPARTMENT	CODE
ADAMS	IT	100
JAMES	IT	200
ADAMS	IT	300
ADAMS	IT	400
JAMES	IT	300
CLARK	AE	400

I am trying to do with Calcuate (expression, allexcept(code) ) which is not working.

After removing ode column the below will be expected results, but my results should be same as above. I hope it is cleared.

NAME	DEPARTMENT
ADAMS	IT
JAMES	IT
CLARK	AE

[RD_PowerBI31]

Any workaournd please.

[ppm1]

Please see this article that shows one way to do that.

Understanding Group By Columns in Power BI - SQLBI

Pat