Forum Discussion

g-wizard's avatar
g-wizard
Frequent Visitor
2 years ago
Solved

If/AND/ElseIF

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

Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago
    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.

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago
    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.