Forum Discussion
Replacing Blank values
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 ....
5 Replies
- Syk
Resident Rockstar
Try this
Status Of Completion = VAR CourseName = SELECTEDVALUE( TRANSACTIONS_EXP[COMPLETION_STATUS] ) RETURN COALESCE(CourseName,"NOT COMPLETE")sorry team,
tried , didn't work..
if any other solution please let me know
- tamerj1
Community Champion
Hi BhagyaRay14
Please try
Status Of Completion =
IF (
ISEMPTY ( TRANSACTIONS_EXP ),
"NOT COMEPLTE",
SELECTEDVALUE ( TRANSACTIONS_EXP[COMPLETION_STATUS], "NOT COMEPLTE" )
)Sorry didn't work
not sure what to do..
If anything kindly let me know
- tamerj1
You need to use dimension tables one for emails and one for courses
