Count organisations in a category

Questions & Answers
1

How do I show the number of organisations in a category per month?

I have a Bar chart that shows Issue count by month, the hierarchy is by category, what I would like to show on a separate axis is the number of organisations per month on top of the issue count (so if issue count rises or drops hopefully so will the number of organisations).

2

Any suggestions would be useful.

3

Hi @Matthew_Singleton,

Please try to use the Count() function in combination with the Filter() and Descendants() functions to count the Organization dimension members. The calculation could look similar to the one below:

Count(
  Filter(
    Descendants([Organization].CurrentMember,[Organization].[Organization]),
    [Measures].[Issues created] > 0
  )
)

Please read more about the mentioned functions on our MDX reference guide and calculated member on our documentation page - https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-members.

Best,
Roberts // eazyBI support