DAX

[Farhana110]

Combining Conditions for Eligibility

Hi,

How to combine below three condition to form calculated column eligible in power bi 1st condition

VAR _firstindex =

MAXX (

INDEX( 1,

SUMMARIZE ( 'Closed- won_table', 'Closed-won_Table'[Lead ID], [Closed - Won_ Table'[Index] ), Order by ('closed - won _ table' [Index], ASC),

KEEP,

PartitionBY (' Closed- won _ table' [lead ID] )), 'Closed - Won_Table' [Index] ) Return

If (closed - won _ table [ Index] = _ first index, " Eligible", " ineligible" )

2nd condition is

VAR _Firstindex1 =

MAXX ( INDEX ( 1,

Summarize ( ' Closed - won_ table', ' Closed - won _ table ' [lead ID], ' Closed- won_Table' [Index] , ASC),

KEEP,

PARTITIONBY ( 'Closed - won_ table'[ Lead ID] )), 'Closed-won_Table' [ Index] ) Return

If ( closed won table [ index] = _firstindex1, " Eligible"," Ineligible")

3rd condition is

If [closed- won _table. Local currency]=0 && [closed - won _ table_ payout in USD] = 0, " ineligible, EMP not found", "eligible")

Appreciate your help in this regards, Thanks!

[Muhammad110]

Try this one ;;

eligible =
VAR _firstindex =
MAXX (
INDEX (
1,
SUMMARIZE (
'Closed- won_table',
'Closed-won_Table'[Lead ID],
[Closed - Won_ Table'[Index]
),
ORDER BY ('closed - won _ table'[Index], ASC),
KEEP,
PARTITION BY ('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],
ASC
),
KEEP,
PARTITION BY ('Closed - won _ table'[Lead ID])
),
'Closed-won_Table'[Index]
)
RETURN
IF (
'Closed - won _ table'[Index] = _firstindex
&& 'Closed - won _ table'[Index] = _Firstindex1
&& 'Closed- won _table'[Local currency] = 0
&& 'Closed - won _ table_ payout in USD] = 0,
"ineligible, EMP not found",
"eligible"
)

[Anonymous · Accepted solution]

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.