How to group projects with multiple categories

Is there a way to group multiple project categories into one calculated member in the project dimension? Or if it’s impossible can I do it in measures?

Thanks.

Found how I can do it, do not forget to select ProjectCategory in dimension.
Aggregate(
Filter(
[Project.Category].[Category].Members,
[Project.Category].CurrentMember.Name MATCHES ‘.ProjecCategory.
)
)

1 Like