Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |