Calculated column using DAX

[Farhana110]

Hi 

I am trying to create a column " Eligible"using dax. I have lead ID column in my table. If this column contains duplicate lead is then 1 St captured lead id should be eligible and other should be in eligible.for example if ID 4566 repeated 3 times ID 4566- eligible 

                             ID 4566- Ineligible 

                              ID 4566 - Ineligible 

Can anyone advice me on this issue. Thanks !

[Jihwan_Kim]

HI, 

I am not sure if I understood your question correctly, but I assume your table has a kind of INDEX column that defines which one is the first one and which ones are not the first one.

Please check the below picture and the attached pbix file.

Expected result CC =
VAR _firstindex =
    MAXX (
        INDEX (
            1,
            SUMMARIZE ( Data, Data[Lead ID], Data[Index] ),
            ORDERBY ( Data[Index], ASC ),
            KEEP,
            PARTITIONBY ( Data[Lead ID] )
        ),
        Data[Index]
    )
RETURN
    IF ( Data[Index] = _firstindex, "Eligible", "Ineligible" )

[Farhana110]

Hi jihwan, 

Thank you so much for your support, DAX is working properly. Could you please help to combine two more condition in above DAX,

1. When payout in local currency =0 and payout in USD = 0 then " ineligible Emp not found"

2.when lead id " L/CR-000000000" or lead id =L/CR - 00000001 then ineligible, duplicate customer 

Else eligible

[Jihwan_Kim]

Hi,

Please share your sample pbix file's link.

Thank you.