Forum Discussion

heathernicole's avatar
heathernicole
Continued Contributor
10 years ago
Solved

SWITCH statement in DAX using a "between this value and this value" as a filter?

VERY new to DAX - I think my issue is I haven't nailed down how to ask the right question yet - which hinders research for an answer:   Trying to create an IF (or a Switch) statement   If "this v...
  • asocorro's avatar
    asocorro
    10 years ago

    The SWITCH statement allows comparisons with constants only.  You need to use an IF statement.  For a calculated column, this is an example:

     

    Pop Classification =
    IF(Population[Pop] >= 1000 && Population[Pop] <= 25000,
    1,
    IF(Population[Pop] >= 25001 && Population[Pop] <= 50000,
    2,
    0)
    )

     

     

  • asocorro's avatar
    asocorro
    10 years ago

    I copied exactly what you posted and it worked for me.  Make sure your data is of type Decimal and not Text.

     

     

  • heathernicole's avatar
    heathernicole
    10 years ago

    Figured it out... or at least partially... it's summarizing data when it shouldn't so it's adding it somewhere.

     

    So all of your suggestions have helped! :) Thank you!!

  • asocorro's avatar
    asocorro
    10 years ago

    I was about to tell you that.  Check the table fields for an aggregate function.

greggyb's avatar
greggyb
Resident Rockstar
10 years ago

Blow someone's mind:

// DAX
// Works anywhere
// Don't do this without a good reason
SWITCH(
    FALSE()
    ,<boolean>, <result if boolean is false)
    ....
    ,<result if all boolean expressions above are false>
)

Then you're testing each expression for equality with FALSE(). So tests that fail get their result evaluated.