Forum Discussion

vrv's avatar
vrv
Helper II
3 years ago
Solved

simple measure

hi all, i need a simple measure DAX expression that checks a bit field and gets a value of "GOOD" when the field tested is 1 AND "BAD" if the tested fields is 0. All my common sense attempts failed...
Need Help
  • saurabhkudale96's avatar
    saurabhkudale96
    3 years ago

    Hello vrv ,
     If you need to have the result in the below format, you need to create a Calculated column. You are not able to enter the column name because you are trying to create a measure. And a column cannot be used in a measure.

    Result = SWITCH(Table_Name[column_name], 1, "GOOD", 0, "BAD")

    OR

    Result = IF(Table_Name[column_name] = 1, "GOOD", "BAD")

     

     

     

vrv's avatar
vrv
Helper II
3 years ago

Hi anybody, any idea?

my question is how do I enter the column name?

what is the correct format?

 

Apparently I can't drag and drop the column in there, so somethign is wrong ...

 

Thank you,

vrv

 

I

saurabhkudale96's avatar
saurabhkudale96
Frequent Visitor
3 years ago

Hello vrv ,
 If you need to have the result in the below format, you need to create a Calculated column. You are not able to enter the column name because you are trying to create a measure. And a column cannot be used in a measure.

Result = SWITCH(Table_Name[column_name], 1, "GOOD", 0, "BAD")

OR

Result = IF(Table_Name[column_name] = 1, "GOOD", "BAD")