Calculate Percent based on different FY measures

Angelia,

For 2016 and 2017 the final YTD_PCT amount should be 100%. Each line represents a monthly cumulative YTD amount for a fiscal year. The percent needs to reflect the monthly YTD amount divided by the total amount for that fiscal year. Looking at the matrix in the sample pbix file, the Aug YTD_EXP for 2017 for Div1, C1 = 642,124 and this amount should be divided by the total for 2017 771,734, which is the amount in the SEP YTD_EXP column. Therefore, the YTD_PCT for Aug 2017 for Div1, C1 should be 83.2% (642,124 / 771,734) and not the 78.4% as reflected in the matrix. The 78.4% represents the Aug 2017 YTD_EXP of 642,124 divided by the total for 2016 which is 984,604.

What makes this complicated, to me atleast, is that the percent for 2016 & 2017 needs to be calculated on the total expenditures for each fiscal year while 2018 is calcualted on total annual budget.

Any insight on how to change the YTD_PCT measure's formula would be greatly appreciated.