DAX

Hi Farhana110 ,

Please hvae a try.

column =
VAR _firstindex =
    MAXX (
        INDEX (
            1,
            SUMMARIZE (
                'Closed- won_table',
                'Closed-won_Table'[Lead ID],
                [Closed - Won_ Table'[Index]
            ),
            ORDERBY ( 'closed - won _ table'[Index], ASC ),
            KEEP,
            PARTITIONBY ( ' Closed- won _ table'[lead ID] )
        ),
        'Closed - Won_Table'[Index]
    )
VAR _Firstindex1 =
    MAXX (
        INDEX (
            1,
            SUMMARIZE (
                ' Closed - won_ table',
                ' Closed - won _ table '[lead ID],
                ' Closed- won_Table'[Index]
            ),
            KEEP,
            PARTITIONBY ( 'Closed - won_ table'[ Lead ID] )
        ),
        'Closed-won_Table'[ Index]
    )
RETURN
    IF (
        'closed- won _table'[Local currency] = 0
            && 'closed- won _ table'[payout in USD] = 0,
        " ineligible, EMP not found",
        IF (
            'closed- won _ table'[ Index] = _firstindex
                || 'closed- won _ table '[ index] = _Firstindex1,
            "eligible",
            "ineligible"
        )
    )

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.