If/AND/ElseIF

[g-wizard]

Hello Team, 

I am having difficulty converting this calc from tableau to pbi dax. Any suggestions?

They both come from different tables that are not related. One is an actual table and the other comes from my Measure Table(stored calculations area)

IF Attr([Channel Partner Customer Classification])="DM" AND [Annualized Sales]<500000 then 0
ELSEIF Attr([Channel Partner Customer Classification])="DM" AND[Annualized Sales]<1000000 then 2
ELSEIF Attr([Channel Partner Customer Classification])="DM" AND[Annualized Sales]<2000000 then 3
ELSEIF [Annualized Sales]<100000 then 0
ELSEIF [Annualized Sales]<250000 then 2
ELSEIF [Annualized Sales]>=1500000 then 10
END

[lbendlin · Accepted solution]

a =
SWITCH (
    Attr[Channel Partner Customer Classification],
    "DM",
        SWITCH (
            TRUE (),
            [Annualized Sales] < 500000, 0,
            [Annualized Sales] < 1000000, 2,
            [Annualized Sales] < 2000000, 3
        ),
    SWITCH (
        TRUE (),
        [Annualized Sales] < 100000, 0,
        [Annualized Sales] < 250000, 2,
        10
    )
)

Note you have a logic gap in both halfs.