Jira multiselect check box

Hello Good People,
I have a multiselect checkbox field wIth vlaues ABC , DEF , GHI
Im trying to create a measure where it shows total number of ABC only issues and ignores if any of the other two is selected.
Tried using the EXCEPT but its not working as expected.

Hi @gagan_m_s

If checkbox field is imported as a dimension in eazyBI, try creating new calculated measure using this formula:

(
[Measures].[Issues created],
[Checkbox field NAME].[ABC]
)

But the same won’t work with except function. Multi-value fields won’t work with Except in the way you expect.
Instead try using this formula:

(
[Measures].[Issues created],
[Checkbox field NAME].DefaultMember
)
-
(
[Measures].[Issues created],
[Checkbox field NAME].[ABC]
)

It will subtract the ABC issues (where any of values is ABC) from all issues.

Martins / eazyBI