Taking First value from duplicates in a column

[SeanN87]

I'm trying to create a dimension table that has Part Numbers and a corresponding Part Description. I successfully created the table with one column of Part Numbers (because those are unique), but depending on the dealership the descriptions can vary slightly. I used this formula to create the single column table:

PartDimension = CALCULATETABLE(SUMMARIZE('Master Part Quantities','Master Part Quantities'[Part_Number]),'Master Part Quantities'[Part_Number] <> BLANK())

But when I add the Part Description field to the groupings, I get a duplicate error:

Is there a way I can change this formula so that it only takes the FIRST part description it finds for each Part Number? I'm new to DAX so I apologize in advance if this is an easy one. 

Any help would be appreciated.

Thanks!

[daxer-almighty · Accepted solution]

[Parts] =
FILTER(
    ADDCOLUMNS(
        DISTINCT( T[Part_Number] ),
        "Description",
            FIRSTNONBLANK( T[Part_Description], 1 )
    ),
    NOT ISBLANK( T[Part_Number] )
)

[SeanN87]

Perfect! Thank you so much for the quick response.