Column - Unique / First Supplier Name of duplicate ABN's

[StidifordN]

Afternoon all, 

This one seem simple in my mind but struggling to solve it with DAX

I have a large supplier database - with some suppliers having multiple entries (for various reasons) but these multiple entries all have a common ABN reference number.   These various suppliers entires may have potentially differing supplier names.

For the example below - I would like a column to the right hand side to populate with just one of the two (or more) supplier names that are available.  The first, or the last... not really important.  But a single unique supplier name column per ABN.

[Anonymous · Accepted solution]

Hi @StidifordN 

Measure = CALCULATE(FIRSTNONBLANK('Table'[SupplierName],TRUE()),ALLEXCEPT('Table','Table'[ABN]))

Please use this measure to get first name for each ABN