Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
SeanN87
Frequent Visitor

Taking First value from duplicates in a column

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:
SeanN87_0-1625848877845.png

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!

 

 

1 ACCEPTED SOLUTION
daxer-almighty
Solution Sage
Solution Sage

 

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

 

View solution in original post

2 REPLIES 2
daxer-almighty
Solution Sage
Solution Sage

 

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

 

Perfect! Thank you so much for the quick response.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.