Parent Table getting filtered with measure filter context

Anonymous — Thu, 12 Dec 2019 18:45:38 GMT

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.

ParentId	ParentName	Completion %
2	XYZ	33%
3	ASD	100%
4	DFG	50%

Please help with this. PBIX is here Code

Re: Parent Table getting filtered with measure filter context

Anonymous — Thu, 12 Dec 2019 20:05:48 GMT

Actually I got it resolved by allowing blank values in the table.

topic Re: Parent Table getting filtered with measure filter context in DAX Commands and Tips

Parent Table getting filtered with measure filter context

Re: Parent Table getting filtered with measure filter context