Pick function help

[pawwy1415]

Hi Experts,

I have a bar chart with Report Date as Dimension and  expression which contains 3 measures.

Pick(Dim,
count({<[NGM Status]={'Nominated'},[Domain Data Sets]={"=len(Trim([Domain Data Sets]))>0"},[Report Date]=>}distinct [ID]),

count({<[NGM Status]={'Governed'},[Report Date]=>}distinct [ID]),
count({<[NGM Status]={'Measured'},[Report Date]=>}distinct  [ID]))

Issue: when i have added these 3 measures as separate i am able to exclude default report date selection and i can see all the dates int the chart but by including these 3 expression under pick function i am not able to exclude the report date.

Could you please help me to modify the above expression.

thanks in advance.

[pawwy1415]

Hi @tresesco ,

Could you please help me on above issue.

Thanks in advance

[tresesco]

Is Dim coming from a data island? Could you share a sample where we can see the issue?

[sunny_talwar]

How about if you try this

Pick(Only({1} Dim),
Count({<[NGM Status] = {'Nominated'}, [Domain Data Sets] = {"=Len(Trim(Only({1} [Domain Data Sets])))>0"}, [Report Date]>} DISTINCT [ID]),

Count({<[NGM Status] = {'Governed'}, [Report Date]>} DISTINCT [ID]),
Count({<[NGM Status] = {'Measured'}, [Report Date]>} DISTINCT [ID]))