Daily total divided by monthly total

[Newbie_1_Kenobi]

I am not having any luck finding an answer so I am not sure if this is even doable. My problem is twofold. My first issue is I am trying to get a weighted average for a total with a filter (so I am using a measure). I am trying to divide the prior year daily total by the prior year monthly total for each month for each filtered category. For example, $1904/$30823 = .061, $1685/$30823 = .054, so on and so on. 

I then need to multiply those percents against one entry on the first of each month that is the target. So I was only given one amount for the whole of January, $29,722. I need to arrive at a daily amount by multiplying the .061 x $29,722 for Jan 1, .054 x $29,722 for Jan 2 and so on and so on. 

Is this feasibile?

[PiEye]

Hi @Newbie_1_Kenobi 

This is complicated at first glance, but breaking the measures in steps makes it a lot simpler. 

I assume you already have expressions to return the latest year, and previous year.

First steps are to work out the daily amounts for the current / previous year and then use that expression to get the total for the month:

exp current yr = CALCULATE([Exp],FILTER(Table1,Table1[year]=[Latest Selected Year]))
exp prev yr = CALCULATE([Exp],FILTER(Table1,Table1[year]=[Prev Year]))

month total current yr = CALCULATE([exp current yr],ALLEXCEPT(Table1,Table1[month]))
month total prev yr = CALCULATE([exp prev yr],ALLEXCEPT(Table1,Table1[month]))

"All except" means ignore all filters (including days), except for month. So we get a month "total" 

I can then use these expressions to work out the day as a % of the month:

day % of month curr = [exp current yr]/[month total current yr]
day % of month prev = [exp prev yr]/[month total prev yr]

To return the total of the target for the month, use a similar syntax to the month total:

CALCULATE(sum(Table1[Target]),ALLEXCEPT(Table1,Table1[month]))

We can then apply this to the daily % to get a daily target for that day of the month:

Prev yr pc X Month Tgt = [day % of month prev] * CALCULATE(sum(Table1[Target]),ALLEXCEPT(Table1,Table1[month]))

HTH

Pi