Help with divide each month value with fixed value power bi

[Anonymous]

Hi,

I have this table:

I have "Cubic of water" column with value every month, and Acres column that declare only on Jan for each year.

I want to divide each month with Acres Jan value for each year.

for example i want something like this:

P.S. I don't really need Acres column in the visual it's just for the explanation.

Thanks

[Anonymous]

Hi,

You can use below Dax in this scenario,

Water for acres = CALCULATE(SUM(Table1[Cubic of Water])/SUMX(FILTER(Table1,Table1[Dates].Year = Selectedvalue = 'Table1'[Year])))

[Anonymous]

Thanks,

But it's not working for me,

What about the Acres Column?