Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Is Dim coming from a data island? Could you share a sample where we can see the issue?
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]))