If Variable is Blank, hide measure

[ZoeM]

Hello!

I am using a variable in my set analysis and I would like to hide the line values if the variable is blank.

So something like, if(isnull(vEvent),'') and the field should be hidden. When the variable has a value then the field should be shown. 

Thanks!

[Fernando_Fabregas]

Hi Zoe. This should be work to hide all values of your measure:

In measure field:

   if('$(vEvent)'<>'', [your measure here] )

This is what you are looking for?

Regards, Fernando

[ZoeM · Accepted solution]

Hi Fernando!

Thanks for the expression. What i got to work was the below as well, it is working as expected. I didnt realize that for text input I could use the len function:

=if(len(vEvent)>0,1,0)

Thanks for the support!