I have a simple aggregate measure that combines two sets of overlapping issues.
How do I get this to show a unique count of issues instead of a sum of the two sets?
@Elita.Kalane , this is my other post. If I can get a unique issue count here, I wouldn’t need to create a custom dimension. Is this problem easier to solve?
Hi, Kristine
Would you mind sharing how you have created measures “Caught by QA” and “QA Reporter Group” (what is their formula)? Also, please describe briefly what you want to count.
Usually, Aggregate() is used when aggregating members of particular dimensions, creating calculated members in this dimension.
In measures, use arithmetical operations or more specific functions like Sum(), Avg()
Kindly,
Ilze support@eazybi.com