Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
@
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!
Date = {"=len(Only({1}[Date])) >=0"}
Date = {"=len(Only({1}[Date])) >=0"}
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)
Thanks! it works
Hello vinieme12
Thanks so much this is another workaround I will take into account!