
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Pick function help
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is Dim coming from a data island? Could you share a sample where we can see the issue?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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]))
