Forum Discussion
Parent-Child
Hi
I have report with alistbar to select a team.
An indicator shows the open tasks for the team.
Each team belongs to a region.
I also want to show an indicator with the open tasks of all teams within the region of the team as selected in the listbar.
How can I do this?
6 Replies
- CNENFRNL
Community Champion
jvandyck , not enough info for a quick solution; but you might want to refer to this document concerning such a Parent-Child question.
- amitchandak
Super User
jvandyck , Task should rollup.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
- jvandyck
Helper IV
This is the structure....it is not parent-child in dax terminology...
Region Team Bruxelles BRUSSEL Litigation and Admin ADMIN Litigation and Admin LITIGATION Operations OPERATIONS Vlaanderen WILRIJK 1 Vlaanderen WILRIJK 2 Vlaanderen WILRIJK 3 Vlaanderen DRONGEN 1 Vlaanderen DRONGEN 2 Vlaanderen HASSELT Vlaanderen KORTRIJK Vlaanderen LEUVEN 1 Vlaanderen LEUVEN 2 Wallonie JAMBES Wallonie LIEGE Wallonie MONS So on my report, I have a listbar populated with team. An indicator shows the open tasks for the selected team.
Now I want to add a measure not only showing the open tasks for the selected team, but for all teams within the region.
So if I select Mons in the listbar, I want to show the open tasks for Mons, Liege and Jambes.
I hope this clarifies what I want to achieve....
- amitchandak
Super User
jvandyck , In this case, prefer the slicer is coming from an independent teams table( Not joined or not from teams column in the table)
Try measure like
measure =
var _region = summarize(filter(Table, Table[team]=selectedvalue(Table[team])), Table[region])
return
calculate(sum(Table[open tasks]), filter(Table, Table[region] in _region))- jvandyck
Helper IV
I cannot get it working, so I would like to attach a mockup pbix file. How can I do that?
- jvandyck
Helper IV
Hi
I have created a mock-up to explain my question. It is available in dropbox: https://www.dropbox.com/sh/ia5ub6szgaimxpo/AAAseSDuewX4xczDMDAIXOkCa?dl=0
Many thanks for your help!