How can i Count special dimension member in eazybi

bina · November 2, 2019, 9:17am

Hi

please help meeeee
please tell me how can i count special dimension member in eazybi in jira?

Thank you

janis.plume · November 13, 2019, 7:50am

Hi,

The solution for counting the dimension members in the report rows could be implemented with the formula like this:

Count(
  Filter([Color].[Color].Members,
  [Measures].[Issues created]>0)
)

In my case, I have the “Color” dimension in the report rows and I added this calculation as one more column to the report:

The idea of this formula is to filter the members of the dimension and check if it the member is returning a value of the measure from my report.

Kindly,
Janis, eazyBI support