SUMX with filter using SELECTEDVALUE

Hey

Im fairly new to Power BI and im trying to solve SUMX to a non-related table.

The table im trying to get correct number from has info like this:

Elements Table:

In my visuals this table works great, since it filters on Project number. And i dont get issues at all. But i cant pull the data based on project number into power bi, I have to get this list with everything in it.

I have made a calendar that uses First date from Start Date and last date from End date. Then made new colums adding:

Week = if(WEEKDAY('Calendar'[Date];2)=1;WEEKNUM('Calendar'[Date]);BLANK())
Year = year('Calendar'[Date])

Year-Week= IF('Calendar'[Week]<>BLANK();'Calendar'[YEAR]&"-"&'Calendar'[WEEK];Blank())

 

Then i removed blank() rows in Week. I need a new column into this calendar table that pulls Demand from elements table so i can show the weeks and what the demand is in that week for the current selected project.

I have tried this so far for a new column:

 

Demand =
IF('Calendar'[Year-Week]=BLANK();BLANK();

CALCULATE(
sumx(filter('Elements';Elements[Projectnumber]="12345678");Elements[Demand]);

'Elements'[Start Date] <= EARLIER ( 'Calendar'[Date] );

'Elements'[End Date] >= EARLIER ( 'Calendar'[Date] )))

 

This works. But not based on the current selected project. As i have written the number in. 

 

i wish this worked:

 

Demand =
IF('Calendar'[Year-Week]=BLANK();BLANK();

CALCULATE(

sumx(filter('Elements';Elements[Projectnumber]=SELECTEDVALUE(Projectlist[Number]));Elements[Demand]); 

'Elements'[Start Date] <= EARLIER ( 'Calendar'[Date] );

'Elements'[End Date] >= EARLIER ( 'Calendar'[Date] )))

 

Thanks for any input on how to solve this.