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
Solved! Go to Solution.
Actually I got it resolved by allowing blank values in the table.
Actually I got it resolved by allowing blank values in the table.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!