Problem transposing SUMIFS to Power BI

Hello 🙂
I'm having problems passing an excel formula to Power BI. In my Excel, I use this SUMIFS formula:

(SUMIFS(sheet1!$S:$S;sheet1!$V:$V;$B$8;sheet1!$E:$E;"D";sheet1!$U:$U;C4))+(SUMIFS(sheet1!$S:$S;sheet1!$V:$V;$B$8;sheet1!$E:$E;"D";sheet1!$U:$U;C5)))/((SUMIFS(sheet1!$S:$S;sheet1!$V:$V;$B$8;sheet1!$U:$U;C4))+(SUMIFS(sheet1!$S:$S;sheet1!$V:$V;$B$8;sheet1!$U:$U;C5))

This formulais used in sheet2 in my Excel. This a image of sheet2:


Using the cell C8 in the image above as an example, the formula adds the values ​​of column S (sheet1), if the column V (sheet1) = "GC" and the column E (sheet1) = "D" and the column U (sheet1) = C4   (and C5 too, in the second condition of the SUMIFS)

I want to pass this formula to Power BI, but I don't know how to do that. I already created a new column in PowerBI that shows the week of the year (which is what the value of C4 and C5 represents), but how would I make the calculation be done dynamically for each week of the year? In my Excel, the calculation is done like this:

the formula takes the values ​​of C4 (week 51 of 2018) and C5 (week 52 of 2018) and makes the calculation.

Can someone help me?