Solved: isnotblank with condition - Page 2

Tragertt · 02-07-2025 11:17 AM

I am looking to a isnotblank() with a condition for a show if expression

I need to combine these 2

isnotblank(question sets[overall Q3]) where [_thisrow].[question set name] = question sets[question set]

im drawing a blank on how to do this, any ideas?

Tragertt

I was able to achieve what I needed to have by setting the default value to this

if(
ISNOTBLANK(SELECT(Question Sets[Overall Q2], [_THISROW].[Questions Set] = [Question Set Name])), "", "Blank"
)

And then a show if statement to

and(ISNOTBLANK([Questions Set]), [Overall Q2] <> "Blank")