undefined

[Anonymous]

I have ID column the formate of it is Text, and ID column has many repetead ID's, I wan to cleare a new column with only distinct ID's.

Thanks in Advance

[V-lianl-msft]

Hi @Anonymous ,

You can try to create a new table:Table2 = DISTINCT('table'[id])

If necessary, you can also create a relationship for the two tables based on the ID.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[selpaqm]

You need to create a new table instead of new measure or column. Click new table on modeling tab.

Unique ID = Distinct('sheet1'(IDcolumn))

[amitchandak · Accepted solution]

You have to get a new table

New table = distinct(table[Column])

You can join your table as dimension

[Tahreem24]

@Anonymous ,

Create new column with below DAX:

Distinct ID = CALCULATE(DISTINCT(table[IDcolumn]))

Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.

[Anonymous]

Thanks for your rpl but I am not getting distinct values instead I am getting same values as it was there in ID column.

[Tahreem24]

@Anonymous ,

So, create a new table and use DISTINCT('Table'[IDcolumn]).

Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.