Forum Discussion
Parent Table getting filtered with measure filter context
Hi Folks - I am facing a filtering problem, might be a simple fix but sorry about my ignorance.
I have a parent table like
| ParentId | ParentName | Sprint |
| 1 | ABC | S1 |
| 1 | ABC | S2 |
| 1 | ABC | S3 |
| 1 | ABC | S4 |
| 2 | XYZ | S1 |
| 2 | XYZ | S2 |
| 3 | ASD | S3 |
| 4 | DFG | S2 |
| 4 | DFG | S3 |
| 5 | ZXC | S4 |
Child table like
| ChildId | ChildName | ParentID | Status |
| 101 | poi | 1 | InProgress |
| 102 | lkj | 1 | BackLog |
| 201 | mnb | 2 | Done |
| 202 | mkl | 2 | InProgress |
| 203 | lop | 2 | BackLog |
| 301 | pol | 3 | Done |
| 401 | ikj | 4 | InProgress |
| 402 | jhy | 4 | Done |
| 403 | gtr | 4 | Done |
| 404 | dfg | 4 | BackLog |
I need to see the completion % of each parent based on the child status. So for eample
1. if parent has 3 children and one of them is "Done" then completion % is 33%[For example parent id 2].
2. If parent has no child then completion % should come Blank for the parent [For example: Parent ID 5].
3. If all the child(ern) are done then it should be 100% [For Example Parent ID 3]
4. If non of the children are done then it should be 0% [For example Parent ID 1]
But when I am calculation in Power BI with measure
Completion % = DIVIDE(CALCULATE(COUNT(ChildTask[ChildId]), ChildTask[Status]="Done"), CALCULATE(COUNT(ChildTask[ChildId])), 0)
and bringing it to a table like Completion Status I am only getting the below parents, for which there is at least one "Done" child. Parent 1 and 5 are completely ignored.