Forum Discussion

PaulinoV's avatar
PaulinoV
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

Fetch value from child work item

Hey community, first time poster here!   I'm extremely new to the Power BI experience and would like some help with this issue.   In my data I have 3 Features that are children of an Epic. Those ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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

 

may be like this

measure  =

countx(filter( values(Table[Feature]), not(isblank([Past due])) ), [Feature])

 

where Past due is a measure and you use only measures in pie no legend 

  • PaulinoV's avatar
    PaulinoV
    Icon for Microsoft Employee rankMicrosoft Employee
    4 years ago

    Hi amitchandak thanks for the prompt response!

     

     

    I will try to better describe my scenario, in my project we have a constant structure

    • Project Name (EPIC)
      • Checkpoint 1 (Feature)
      • Checkpoint 2(Feature)
      • Checkpoint 3 (Feature)

    Each of those checkpoints has a Start Date and a Target Date, what I'm looking for is a donut chart that whenever one of the 3 checkpoints is "past due" shows that one Epic is late (regardless if it's checkpoint 1,2,3), as of right now it just counts the number of checkpoints that are late (several checkpoints can be delayed in one epic).

     

    I created a column in the Features table to keep track of the past due checkpoints:

     

    Past Due = if(DATEDIFF(Features[TargetDate],TODAY(),DAY)<0,"Current", if(DATEDIFF(Features[TargetDate],TODAY(),DAY)>=0 AND Feature[State] <> Closed, "Past Due"))
     

    As seen in this image below

     

     

    I would like it to count 1 epic, regardless if its one, two or three checkpoints delayed, same for "current" or "on time" status.

     

    Short story I would like that every time that one checkpoint is late it flags, counts the parent epic.

     

    (i'm trying to get a file with sensible data removed)

     

    Hopefully I was able to explain myself better 🙂 

     

    Thanks in advance for your help!