Parent-Child

[jvandyck]

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?

[amitchandak]

@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]

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!

[jvandyck]

I cannot get it working, so I would like to attach a mockup pbix file. How can I do that?

[jvandyck]

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]

@jvandyck , Task should rollup.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[CNENFRNL]

@jvandyck , not enough info for a quick solution; but you might want to refer to this document concerning such a Parent-Child question.