reduce duplicate combinations of columns in calculated table

[czaldumbide]

Hi Everyone,

I used DISTINCT( SELECTCOLUMN ('table'[id], "ID", 'table'[b-type], "Business Type") to create a calculated table.

The table now has unique combinations of ID and Business Type.

EX:

ID	Business Type
1	B
2	F
3	F
3	P

How can I modify my calculated column so I only get one row per ID. Meaning in those cases where there are multiple Business Types per ID I just want to select one. It can be the highest alpanumeric value or simply the first value it encounters ( don't care the condition as long as it provides single value). 

EX

ID	Business Type
1	B
2	F
3	F

Any help with this would be greatly appreciated.

Thanks

[camargos88 · Accepted solution]

Hi @czaldumbide ,

Try this code to create a new table using DAX:

T = SUMMARIZE('Table (2)'; 'Table (2)'[ID]; "BusinessType"; MIN('Table (2)'[Business Type]))

Ricardo