Forum Discussion
venkata
8 years agoRegular Visitor
Need some help with DAX
I am getting below error. Error Message: MdxScript(Model) (11, 118) Calculation error in measure 'StationList'[Measure]: Function 'SWITCH' does not support comparing values of type Text with val...
mattbrice
Solution Sage
8 years agoIs StationList{STATION] a number or text? Either way, it is trying to compare it to "OTHER" (which is text) or to 'UnSelectedGross' which i assume is an integer. This is not allowed. All comparisons must be one or the other.
- venkata8 years agoRegular Visitor
It is a text