Forum Discussion

strikw's avatar
strikw
Icon for Helper I rankHelper I
8 years ago
Solved

Compare a String to measure

Hello,   I would like to make a comparison with a string of a column, I could not use the if, and I do not know which function is suitable for comparing string.   Ex: Table 1, cololuna1: a b c...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi strikw,

     

    Do you want to count the "AB" values?

     

    You should use something like:

     

    Measure = CALCULATE(COUNT(Table1[Column1]), Table1[Column1] ="AB" )

    Regards,

    MFelix

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi strikw,

 

Do you want to count the "AB" values?

 

You should use something like:

 

Measure = CALCULATE(COUNT(Table1[Column1]), Table1[Column1] ="AB" )

Regards,

MFelix

  • strikw's avatar
    strikw
    Icon for Helper I rankHelper I
    8 years ago

    Hello,

     

    In this case I do not want to do a count, I want to take this value to create a condition.

    For example, all "ab" values will return me blank.

     

    Have a great day.Att, Paulo Dantas.

    • MFelix's avatar
      MFelix
      Icon for Super User rankSuper User
      8 years ago

      Do you want to do it at a column level? or compare all values from a specific range?

       

       

      • strikw's avatar
        strikw
        Icon for Helper I rankHelper I
        8 years ago

        Hello,

        Just for the column.