Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

LOOKUP VALUE FOR DUPLICATE IDs

Hey gurus,   Appreciate your help on the below.   I have a table that has IDs and flags ID         Flag 888          Y 888          N 999          N 999          N     I want to return Y ...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please check the below picture and the attached pbix file, whether it works.

    It is for creating a new table.

     

     

     

    New ID Table =
ADDCOLUMNS (
    SUMMARIZE ( Data, Data[ID] ),
    "@Flag", IF ( "Y" IN CALCULATETABLE ( DISTINCT ( Data[Flag] ) ), "Y", "N" )
)
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

Please check the below picture and the attached pbix file, whether it works.

It is for creating a new table.

 

 

 

New ID Table =
ADDCOLUMNS (
    SUMMARIZE ( Data, Data[ID] ),
    "@Flag", IF ( "Y" IN CALCULATETABLE ( DISTINCT ( Data[Flag] ) ), "Y", "N" )
)