Forum Discussion

Clint's avatar
Clint
Helper V
7 years ago
Solved

Using isBlank to return blank when no value provided in a field

Hello,   Trying to use the following as part of an if statement to suppress the return of a RYG indicator but getting the error "A single value cannot be determined for column "Task Finish Baseline...
Need Help
Clint's avatar
Clint
Helper V
7 years ago

Hello Cmcmahan,

I was able to work in the Selected Value option you outlined in the following calculation

C_Task MS RYG2 =
If(SELECTEDVALUE('TaskBaselines'[Task Baseline Finish Date],BLANK()),
 
And this doesn't throw any errors but it also doesn't return an indicator when it should (per the embedded screenshot)

 
All of the Milestones but the first one should show a RYG indicator in the last column in the table (The status column is calculated using a straight "if" calculation w/o trying to supprese the indictaor when there is no target date.
Cmcmahan's avatar
Cmcmahan
Resident Rockstar
7 years ago

Hmm... that looks like it should work.  So we get to start debugging.

 

Can you create a few test measures and put them into the table for me?

Test1 = SELECTEDVALUE('TaskBaselines'[Task Baseline Finish Date])
Test2 = 'tasks'[Task Finish Variance Days]

If you don't get the expected values for these, then we know what part of the main C_Task MS RYG2 indicator we need to examine/fix.