Apply Month Calculation to Row Without Changing Month Calculation
I have this measure: MonthChange = sumx(VALUES('Calendar'[Month Year]),[Gross Adds]- CALCULATE([Gross Adds],SAMEPERIODLASTYEAR('Calendar'[Calendar Date])))/sumx(VALUES('Calendar'[Month Year]),[Gross Adds]) The result gives me an overall % change for the month compared to last year as -.11%. I wanting to multiply the -.11% to PYSalesByWeek measure. However [Month Change] will compute by row instead of overall month. % Applied = [PYSalesByWeek]+([MonthChange]*[PYSalesByWeek]) I'm wanting to remain at -.11. instead of -.08 and -.1.32, respectively. How to accomplish? PYSalesByWeek Week Ending Date Gross Adds MonthChange % Applied 2948 10/27/2024 0:00 2722 -0.08 2716.23 2911 11/3/2024 0:00 749 -1.32 -921.10