Simple question counting by dimension

Hello,

Let’s say that I have a CSV with USER and GROUP and I want to count users by group

How can I solve this in eazyBI?

Hi David,

You can create a new calculated member where you generate a list of users in each group and then count them. The formula would be similar to following

Count(
Generate(
  NonEmptyCrossJoin(
    Descendants([Group].CurrentMember, 
      [Group].[Group]),
    [User].[User].Members),
  [User].CurrentMember
))

Please let me know if you have further questions regarding this!
Kind regards,
Lauma / support@eazybi.com

1 Like