Ignore all selections doesn't work with a condition

[Anonymous]

@

Hello all,

I would like to ignore all the selections done for a graph. I am aware that inserting '1' in front of all the condition it should work as follows:

sum({1<[Project]={'X'},Date = {"=len([Date]) >=0"},Quarter={'Q1'},[Año Presentación]= {$(=Year(Today())) ,$(=Year(Today())-1) },[State =-{'WWW}>} Object)

but in my case it is not working due to this part of the expresion: Date = {"=len([Date]) >=0"} , If  I remove this part out of my expression the 1 Set analysis condition works perfectly.

Could you please advice on how I should proceed to ignore all my selections with this part I need Date = {"=len([Date]) >=0"}  in the expression?

Thanks in advance!

[swuehl · Accepted solution]

Date = {"=len(Only({1}[Date])) >=0"}

[vinieme12]

create a flag in Load script

if(len([Date]) >=0,1,0) as Flag_DateLen

then replace

sum({1<[Project]={'X'},Flag_DateLen= {1},Quarter={'Q1'},[Año Presentación]= {$(=Year(Today())) ,$(=Year(Today())-1) },[State =-{'WWW}>} Object)

[Anonymous]

Thanks! it works

[Anonymous]

Hello vinieme12

Thanks so much this is another workaround I will take into account!