I have a problem I need help with, I am still a newbie in Power BI.
I created Total measure to add scope1 and scope2. The issue I am facing is the take the Total of the "Baseline 19/20" which is 1121 and use it to divide total of "Actual 20/21, Actual 21/22, Actual 22/23". Hence, I want my result to be
Please note if Actual 23/24 appears it will automatically do the calculation. Can you help me please?