Members involvement

[bigboss]

I want a question. Below example, I want to subtract [Members].[C]. But, here is important things that [Members].[C] when [Members].[A] is included.
For example)
“[Members].[A] + [Members].[B] -
CASE WHEN
[Members].[A] IN [Members].[C] THEN
[Members].[C]
END”

Please help me. I am very desperate.

[zane.baranovska]

Hi @bigboss,

There are several techniques for calculated measures to subtract duplicates.

1. For the Jira issues cube, a few measures would show a unique issue count even if the issue is assigned to members A and C. For example, “Issues created count” and “Issues resolved count”. See the documentation of available metrics: Jira Core measures and dimensions

2. you can use calculated measuresfor more complex use cases. Here are several community posts on similar topics:

   • Remove duplicate tickets
   • Adding 2 measures and not showing duplicate results
   • Calculated two kind of labels

You might want to watch this training video on how to translate JQL (Jira query language) criteria to the eazyBI reports and calculations for a better understanding of the data and how they are related:
Filter Data: How to Translate JQL to eazyBI

Best,
Zane / support@eazyBI.com