Count of unique values

Questions & Answers
1

I have a cascading customfield. I want to show unique count of all Parents .
eg: Field name is Portfolio .
Issue 1 - Portfolio 1
Issue 2 - Portfolio 1
Issue 3 - Portfolio 2
Issue 4 - Portfolio X
Issue 5 - Portfolio X
so i want to have total count of all Portfolios. So my custom calculated member should return 3 .

How to achieve this.

2

Hi @mizanalisayed,

You reached out to us directly via the support email. I will share the answer you accepted with the community below:

I created a similar case with the select list (cascading) field “Product”. Once the custom field is imported as a dimension, you can define a calculated measure similar to the one below:

NonZero(Count(
  Filter(
    [Products].[First].Members,
    [Measures].[Issues created] > 0
  )
))

Please replace the reference to the Product dimension with your dimension. The level “First” indicates that the calculation should consider only the first-level members of the cascading select. The result could look similar to the one below:

SCR-20240229-pmun
SCR-20240229-pmun1880Ă—1080 227 KB

Please look at our documentation page for more information on defining calculated measures - ​Calculated measures and members.

Best,
Roberts // support@eazybi.com

1 Like
3

Thanks Roberts :slightly_smiling_face:
The solution works as expected.