Forum Discussion

jvandyck's avatar
jvandyck
Icon for Helper IV rankHelper IV
5 years ago

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 tea...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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's avatar
jvandyck
Icon for Helper IV rankHelper IV
5 years ago

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