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 b...
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.