Replacing Blank values

[BhagyaRay14]

Hi Team,

I have created a measure : 

Status Of Completion =

VAR CourseName = SELECTEDVALUE( TRANSACTIONS_EXP[COMPLETION_STATUS] )

RETURN

IF( CourseName = BLANK(), "NOT COMEPLTE", CourseName )

this is the result i get it 

I want to replace the blank values with Not Complete

Kindly anyone help ....

[tamerj1]

Hi @BhagyaRay14 

Please try

Status Of Completion =
IF (
ISEMPTY ( TRANSACTIONS_EXP ),
"NOT COMEPLTE",
SELECTEDVALUE ( TRANSACTIONS_EXP[COMPLETION_STATUS], "NOT COMEPLTE" )
)

[BhagyaRay14]

Sorry didn't work

not sure what to do..

If anything kindly let me know

[tamerj1]

@BhagyaRay14 

You need to use dimension tables one for emails and one for courses 

[Syk]

Try this

Status Of Completion =
VAR CourseName = SELECTEDVALUE( TRANSACTIONS_EXP[COMPLETION_STATUS] )
RETURN
COALESCE(CourseName,"NOT COMPLETE")

[BhagyaRay14]

sorry team,

tried , didn't work..

if any other solution please let me know