How can I filter and calculate tasks for 1 or many projects. Get the % calculated and completed

[Mardojel]

Hello experts.

I have recently started in PowertBI, but I am spending a lot of time researching and learning every day.

At this moment I need help, because I have not advanced for a long time, because I want to be able to see the %estimated and actual% percentage of a task in a line graph.

I would like to have only the end date (for week) in my graph, I based it on a method that I saw on YouTube at the month level.

When I filter in PowerQuery by only 1 project I get the result I want, but I have problems when I have all the projects and tasks.

Here I have bad calculation for the %projected and also real %completed, over 1=%100:

When I filter in powerquery by 1 project, the calculation works

%Percent OK for 1 project, but i would like to get this result with all the projects and then filter from the slice for a specific project

OK line chart for 1 project

In DAX I don't know how to filter and then perform the calculation

I attach the data and PBIX

Data and PBIX 

Thanks!

[Mardojel · Accepted solution]

I solved my problem, I never saw it because I didn't study hard enough.

with ALLSELECTED I was able to bring the total value of the field that I needed at the time of filtering.

I would only have to adjust my graph or calculation so that the end date month does not continue drawing.

do not continue drawing after the last due date.