Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Parent-Child Hierarchy Filtering Conditions

Hi, I am very new in Power BI and have following issue to find the right formula combination in Power BI. Is this possible in Power BI and if yes how can I realize thi? Thanks in Advance 🙂   ...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

AllisonKennedy  after working with real data I realized that the measure are not showing everytime the right results:

Instead of showing the Items with"Apple" on state "To Do" AND "Pear" on state "Done", the formula is showing also the Items with "Apple" on state "In Progress" AND "Pear" on state "Done"- do you have any idea why this happens? Below is the measure that I used for this.

 

Measure  = IF (ISBLANK
(MAXX(FILTER('Project Tracker',CONTAINSSTRING(SELECTEDVALUE('Project Tracker'[Title]),"Apple")&&'Project Tracker'[State]="To Do"),'Project Tracker'[Parent Work Item Id])),"NO",IF
(MAXX(FILTER('Project Tracker',CONTAINSSTRING(SELECTEDVALUE('Project Tracker'[Title]),"Apple")&&'Project Tracker'[State]="To Do"),'Project Tracker'[Parent Work Item Id])=
MAXX(FILTER('Project Tracker',CONTAINSSTRING(SELECTEDVALUE('Project Tracker'[Title]),"Pear")&&'Project Tracker'[State]="Done"),'Project Tracker'[Parent Work Item Id]),"YES","CHECK")
)
AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous  The measure looks ok. If you're getting a result for Parent Work Item Id that means that at least one of its children is Apple To Do and at least one of its children is Pear Done. Is it possible that there's also a third child that is Apple In progress? 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    AllisonKennedy  there are also other childs wich has the states "To Do", "In Progress" or "Done", but these childs has diffrent titles/names as seen on the graphic below. I checked it and there is no futher Apple with a state "In Progress". Do you think a change in the formula from "at least" to "exactly" can help us here? 

     

     

     

     

     

  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous  Sorry for the delay - are you still struggling with this one? Not sure which 'at least' you're referring to?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    AllisonKennedy  Issue is solved now. I delete the parts with SELECTEDVALUE and include in the table only the fields "Parent ID" and "Measure". It doesnt work if "Child ID" is also included in the table - this was the problem 😉

     

     

  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion
    6 years ago
    Awesome! Glad it's working.