Forum Discussion

heathernicole's avatar
heathernicole
Icon for Continued Contributor rankContinued 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.

asocorro's avatar
asocorro
Icon for Skilled Sharer rankSkilled Sharer
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.

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Ascorro,

Quick question, what if i want to create a measure with the decimal values in a column using the same switch scenario as given. How can it be acheieved? Please guide me on this.