How to find the count of issues with EMPTY Case Numbers and NON EMPTY Case Numbers

Hi @Arunava,

The formula does not have reference to existing measure, and therefore does not work as expected. A measure binds data together and allows to represent data from different points of view (Dimensions). Therefore, each calculated measure should contain at least one already existing measure to get the context of dimensions used in the report. The measure is a treasure!

To make this calculation work, you may add one more filtering criteria containing measure Issues created:

      IsEmpty([Measures].[Issue Case]) AND
      --measure to add context of the report
      [Measures].[Issues created] > 0 )

Thanks, @Alex_Cheng for the suggested solution to validate by value (none).
This solution works when the custom field “Case” is imported as a property and as a dimension. For the dimension, eazyBI generates value (none) to group issues without “Case”.

If the custom field “Case” is imported only as property, then should use IsEmpty() because issues without case have no value.

Zane /

1 Like