Forum Discussion

Farhana110's avatar
Farhana110
Frequent Visitor
3 years ago

Calculated column using DAX

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 !

3 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    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's avatar
      Farhana110
      Frequent Visitor
      3 years ago

      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's avatar
        Jihwan_Kim
        Super User
        3 years ago

        Hi,

        Please share your sample pbix file's link.

        Thank you.