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

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.

Clint's avatar
Clint
Icon for Helper V rankHelper V
7 years ago

Hi CMcMahan,

 

After futzing w/this a bit, I finally got it to work correctly with this DAX:

Updated PR MS Indicator calc

M_Task MS RYG2 =

If(

isBlank(Max('taskbaselines'[Task Baseline Finish Date])),

BLANK(),

If(MAX('Tasks'[Task Finish Variance Days])<=7,"https://Aristocratgaming.sharepoint.com/sites/pwa/_api/Projectdata/_layouts/15/inc/PWA/images/cf_6p.png" ,

if(MAX('tasks'[Task Finish Variance Days])>=21,"https://Aristocratgaming.sharepoint.com/sites/pwa/_api/Projectdata/_layouts/15/inc/PWA/images/cf_2p.png" ,

"https://Aristocratgaming.sharepoint.com/sites/pwa/_api/Projectdata/_layouts/15/inc/PWA/images/cf_1p.png"

)))