cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jvandyck
Helper III
Helper III

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 6
amitchandak
Super User IV
Super User IV

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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!

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

 

jvandyck
Helper III
Helper III

This is the structure....it is not parent-child in dax terminology...

RegionTeam
BruxellesBRUSSEL
Litigation and AdminADMIN
Litigation and AdminLITIGATION
OperationsOPERATIONS
VlaanderenWILRIJK 1
VlaanderenWILRIJK 2
VlaanderenWILRIJK 3
VlaanderenDRONGEN 1
VlaanderenDRONGEN 2
VlaanderenHASSELT
VlaanderenKORTRIJK
VlaanderenLEUVEN 1
VlaanderenLEUVEN 2
WallonieJAMBES
WallonieLIEGE
WallonieMONS

 

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 IV
Super User IV

@jvandyck , Task should rollup.

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

CNENFRNL
Super User III
Super User III

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors