Forum Discussion
Continued ContributorSWITCH statement in DAX using a "between this value and this value" as a filter?
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)
)I copied exactly what you posted and it worked for me. Make sure your data is of type Decimal and not Text.
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!!
I was about to tell you that. Check the table fields for an aggregate function.
Skilled SharerI copied exactly what you posted and it worked for me. Make sure your data is of type Decimal and not Text.
Continued ContributorHmm.... I'm glad it's working.. .at least for someone. :)
Here's what it's doing to mine...
- heathernicole
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
I was about to tell you that. Check the table fields for an aggregate function.
- greggyb
Resident Rockstar
SWITCH() can only compare to a constant, this is true, but you can still utilize it to avoid nested IF()s for a cleaner syntax and easier modification.
Simply match against the constant TRUE(), then each of your tests (which are Boolean expressions anyway) are tested for equality with TRUE():
// DAX // SWITCH() instead of nested IF() - works in measure, column, or table SwitchTrue = SWITCH( TRUE() ,<boolean expression>, <result if true> ,<boolean expression>, <result if true> , ..., ... ,<else condition - no trues above> )
