Set Analysis for len function

[SkitzN27]

Hi guys,

Can anyone tell me how can I write this expression in set analysis?

Count( distinct {<[Date]-={'NULL'}>} if( len([Date])>0 ,[Date]&[Dimension_1]&[Dimension_2]   ,null()))

I have tried this but this gives me a different count:

Count( distinct {<[Date]-={'NULL'},[Date]={"=len(trim([Date]))>0"}>} [Date]&[Dimension_1]&[Dimension_2])

[Anil_Babu_Samineni · Accepted solution]

Perhaps this?

Count( distinct {<[Date]-={'NULL', "=len(trim([Date]))<0"}>} [Date]&[Dimension_1]&[Dimension_2])

[SkitzN27]

Thanks so much! @Anil_Babu_Samineni