DAX Help

[Train23]

Hello I need some help with the following DAX Syntax.

I have a Measure [total qty] and need to get some DAX to do the following:

If [total qty] < 1000, Then Divide[total qty] by 1.  If [total qty] < 5000 Then Divide [total qty] by 2, IF [total qty] < 50000, Then Divide [total qty] by 4, IF [total qty] > 50000 then Divide [total qty] by 6.

The multiple conditions are tripping me up.

Thank you

[vicky_ · Accepted solution]

You can use the SWITCH function to avoid multiple IF statements - i.e

Your Measure = SWITCH(TRUE(), 
    [total qty] < 1000, Divide([total qty], 1),
    [total qty] < 5000 Divide([total qty], 2), 
    [total qty] < 50000, Divide([total qty], 4),
    [total qty] > 50000, Divide([total qty], 6)
)

[Train23]

Vicki, you ROCK thank you so very much, this WORKS.  I have spent the last 2 days trying to get it working.  THANK YOU for being part of this great community.