Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Create Non Numeric (String) measure using IF and ELSE condition

Something like DATA = If(TableA= "ABCD", "LARGE", "SMALL")

I need to create this as a measure because i need to use it in another measure which where i will be using this XYZ and another number condition

Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Anonymous,

     

    You can simply add "min" or "max" to the column. Please refer to the snapshot below. BTW, a measure needs the context in the visual.

     

    MeasureName =
IF ( MIN ( Table1[ColumnA] ) = "ABCD", "LARGE", "SMALL" )

     

    Create-Non-Numeric-String-measure-using-IF-and-ELSE-condition

     

    Best Regards,
    Dale

4 Replies

  • reza_rad's avatar
    reza_rad
    Advocate IV
    7 years ago

    A table cannot be equal to a text value. In DAX, you cannot say TableA="ABCD". If you want a cell value to be equal to that, you have to mention the column name, and also filter the rows to get to the row that you want. Or alternatively, you have to use functions that search the entire column, such as Contains.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Sorry it should have been  MeasureName = If(Table(ColumnA)= "ABCD", "LARGE", "SMALL")

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        7 years ago

        Hi Anonymous,

         

        You can simply add "min" or "max" to the column. Please refer to the snapshot below. BTW, a measure needs the context in the visual.

         

        MeasureName =
IF ( MIN ( Table1[ColumnA] ) = "ABCD", "LARGE", "SMALL" )

         

        Create-Non-Numeric-String-measure-using-IF-and-ELSE-condition

         

        Best Regards,
        Dale