topic Re: Calculated column using DAX in DAX Commands and Tips

Calculated column using DAX

Farhana110 — Fri, 05 May 2023 05:53:02 GMT

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 !

Re: Calculated column using DAX

Jihwan_Kim — Fri, 05 May 2023 06:49:26 GMT

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" )

Re: Calculated column using DAX

Farhana110 — Fri, 05 May 2023 10:42:40 GMT

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

Re: Calculated column using DAX

Jihwan_Kim — Sat, 06 May 2023 15:39:28 GMT

Hi,

Please share your sample pbix file's link.

Thank you.