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 teams within the region of the team as selected in the listbar.

How can I do this?

 

 

6 Replies

  • jvandyck , Task should rollup.

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

  • 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....

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