Forum Discussion

RyotNomad's avatar
RyotNomad
Frequent Visitor
6 years ago

Use an if statement to replace values returned by a table

I have a table with a column that contains only 1 or 0. However when I put this into my pie chart my legend shows 1 and 0. I cannot change the values in the table adn I'd prefer not to create a new t...
Need Help
az38's avatar
az38
Community Champion
6 years ago

RyotNomad 

you have a good and correct statement

 = IF('applicant'[col] = 1, "Yes", "No")

please, show text of Error

RyotNomad's avatar
RyotNomad
Frequent Visitor
6 years ago
The syntax for "Yes" is incorrect. (DAX(IF( (Applicant[X6_13]) = 1. "Yes", "No"))).
 
 
My actual column name is X6_13. I don't know why it's putting a full stop after the 1. It's clearly a comma in my DAX statement
 
My exact Code:
Column= IF( (Applicant[X6_13]) = 1, "Yes", "No")
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi RyotNomad,

    What type of value existed in your 'x6_13' field? Please check it to use the correct value in your if statement: (you can't directly use equal operator to compare with text and number value)

    Number version:

    Column =
IF ( Applicant[X6_13] = 1, "Yes", "No" )

    Text version:

    Column =
IF ( Applicant[X6_13] = "1", "Yes", "No" )

    Notice: please also check your calculated column data type if it does not recognize as a text value.

    If above not helps, can you please share more detail information about your scenario? 

    How to Get Your Question Answered Quickly 

    Regards,

    Xiaoxin Sheng

    • RyotNomad's avatar
      RyotNomad
      Frequent Visitor
      6 years ago

      Unfortunately neither of those worked. 

       

      I'm not sure what you mean by the calcualted column data type being recognized as a text value.

       

      I've included a screenshot of the data.

       

      https://imgur.com/a/c4VFVN4

       

      Every table is linked to applicant via foreign id

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        HI RyotNomad,

        Table fields can't direct use in measure formula, it can calculate and compare with aggregate values do you need to use aggregate functions to pack your table fields. (e.g. max, min, sum...)

        Power BI DAX Aggregate Functions 

        Measure=
IF ( max(Applicant[X6_13]) = 1, "Yes", "No" )

        In addition, I'd like to suggest you take a look at the following blog about the difference between the calculated column and measure to help you know more about the difference and usage of these calculated fields:

        Calculated Columns and Measures in DAX 

        Regards,

        Xiaoxin Sheng