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?
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