I have the need to be able to create a aggregate on the sprint board to filter just to specific our group of boards
Tried
Aggregate({
Filter(
[Sprint].[Board].Members,
[[Board].Members] = “UCL Scrum Board”
)
})
Hi,
I would recommend using bookmark functionality and then aggregate the group of boards. The {} are special brackets and they create one set from members. Please read more on Aggregate().
If you still want to use filter() function by specific names then you would most likely need to use a combination of MATCHES function and get the board name for comparison -
[Sprint].[Board].CurrentHierarchyMember.Name
Hope that helps.
Gvido Neilands, flex.bi
1 Like