Forum Discussion

Clint's avatar
Clint
Icon for Helper V rankHelper 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
Cmcmahan's avatar
Cmcmahan
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Ah, yes.  Matrix vs table.

 

Every value in a matrix is assummed to be some sort of aggregation of data, grouped by the current row(s) and column(s).  Values in a table are just pulled directly from a table.  You were able to create the calculated table with no issues, but now the matrix is trying to aggregate those values.

 

You should be able to use this measure instead to return the proper value with the code:

SELECTEDVALUE('Taskbaselines'[task baseline finish date],BLANK())

This will select the first value from whatever the current filter context is, or null if there are no options or multiple options. 

 

If you start having problems with totals showing up that you don't want, you can see my recent adventure fighting with a matrix here: https://community.powerbi.com/t5/Desktop/Only-Total-Select-Values-in-a-Matrix-amp-Formatting-Help/m-p/710741#M343163

Clint's avatar
Clint
Icon for Helper V rankHelper 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.