Forum Discussion

SeanN87's avatar
SeanN87
Frequent Visitor
5 years ago
Solved

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:

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's avatar
    daxer-almighty
    5 years ago

     

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

     

2 Replies

  • daxer-almighty's avatar
    daxer-almighty
    Solution Sage
    5 years ago

     

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

     

    • SeanN87's avatar
      SeanN87
      Frequent Visitor
      5 years ago

      Perfect! Thank you so much for the quick response.