Forum Discussion

kelly008's avatar
kelly008
Icon for Helper I rankHelper I
4 years ago
Solved

Replacing (BLANK) field with Text

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.
Need Help
  • vojtechsima's avatar
    vojtechsima
    4 years ago

    Hi, kelly008 
    Try this

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

6 Replies

  • vojtechsima's avatar
    vojtechsima
    Icon for Super User rankSuper User
    4 years ago

    Hi, kelly008 
    try this:

    MKMachineBlank = IF( ISBLANK('MaintenanceRequired2') || 'MaintenanceRequired2' = "", "Machine Check Not Carried Out", 'MaintenanceRequired2')
     
    • kelly008's avatar
      kelly008
      Icon for Helper I rankHelper I
      4 years ago

      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's avatar
        vojtechsima
        Icon for Super User rankSuper User
        4 years ago

        Hi, kelly008 
        Try this

        MKMachineBlank = 
var CurrentItem = SELECTEDVALUE('Preventative Maintenance Log'[MaintenanceRequired2])
return IF( ISBLANK(CurrentItem )||CurrentItem = "", "Machine Check Not Carried Out",  CurrentItem)
         
  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      kelly008
      Icon for Helper I rankHelper I
      4 years ago

      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.