Hi Folks - I am facing a filtering problem, might be a simple fix but sorry about my ignorance.
I have a parent table like
Child table like
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
Please help with this. PBIX is here Code
Go to Solution.
Actually I got it resolved by allowing blank values in the table.
View solution in original post
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.