I have a budget to actuals matrix that has a measure for the rolling variance between the budgets and actuals on there. So if the % spent is 10% on month and 15% the next, then that month would say 25%.
My code looks like this, it works on one matrix but not the others. I think it may have to do the the "ALLEXCEPT" line. though i dont know for sure.
% Spent EXP = IFERROR ( CALCULATE ( SUM ( GLEntry[Expense] ), FILTER ( ALLEXCEPT(GLEntry,Glacount[Account]), GLEntry[Entry_date] <= MAX ( GLEntry[Entry_date] ) ) ) / CALCULATE ( MAX( GLEntry[Expense Budget] ) ), 0 )
Here is what the matrix currently looks like as well.
Could you please share your sample data or pbix to me? if you don't have confidential data. Please upload your files to One Drive and share the link here.