Replacing (BLANK) field with Text

[kelly008]

Hello,

I am currently trying to replace a (blank) field with the text "Machine Check not Carried Out". The column itself is also in text format.

However, I can't seem to find the correct measure:

MKMachineBlank = IF( 'MaintenanceRequired2' = 0, "Machine Check Not Carried Out", 'MaintenanceRequired2') 

I'm currently using the above, but it appears that this measure is for replacing a number field that is displaying a (blank) as apposed to my situation where I want to replace a text field (blank) with text.

Any help would be much appreciated.

Thanks.

[Pragati11]

HI @kelly008 ,

What is the datatype of the column MaintenanceRequired2 in your table?

Is MaintenanceRequired2 a column in your table or measure?

If it is a column and is of text datatype, then use the following DAX expression:

MKMachineBlank =
IF (
    ISBLANK ( yourTable[MaintenanceRequired2] ) = TRUE(),
    "Machine Check Not Carried Out",
    yourTable[MaintenanceRequired2]
)

In the above DAX expression just replace yourTable with the table name you have at your end.

[kelly008]

Hi, thanks for replying.

I'm getting this error after using the measure you suggested:

I'm guessing this is becuase I didnt share the table name? Please see below:

Again, thank you for replying.

[vojtechsima]

Hi, @kelly008 
try this:

MKMachineBlank = IF( ISBLANK('MaintenanceRequired2') || 'MaintenanceRequired2' = "", "Machine Check Not Carried Out", 'MaintenanceRequired2') 

[kelly008]

Hi, thanks for replying, sorry I may not have included all of the relavent information. 

I'm currently getting this error after using the measure you suggested:

I'm guessing this is becuase I didnt include the table that the column is coming from? This is the table alongside the column and the measure you suggested:

Again, thank you for replying.

[vojtechsima · Accepted solution]

Hi, @kelly008 
Try this

MKMachineBlank = 
var CurrentItem = SELECTEDVALUE('Preventative Maintenance Log'[MaintenanceRequired2])
return IF( ISBLANK(CurrentItem )||CurrentItem = "", "Machine Check Not Carried Out",  CurrentItem)

[kelly008]

Thats it! Thank you!