% Change showing wrong totals

Question

Hi,&nbsp;I'm trying to get the percentage change MoM and YoY of a score assigned to each account (Average value of User scores).Each account can have multiple users, and users are added over time.&nbsp;I've tried calculating it with 2 measures:Total_Previous_Period =CALCULATE(AVERAGE(Fact_Score_Weekly[Total]),PREVIOUSMONTH(Dim_Calendar[Date]))&nbsp;Total_Change% = DIVIDE((AVERAGE(Fact_Score_Weekly[Total])-[Total_Previous_Period]),[Total_Previous_Period],0)&nbsp;However, this solution seems to give wrong totals (Each column represents months, bolded row is account, other rows are usersFor month 3 the bolded value should be -0.19% and not 0.63%&nbsp;&nbsp;Thanks in advance!

amitchandak · Answer

Anonymous , hope there is a year filter otherwise use month year on the column, and that should come from the date table 
&nbsp;
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hwhttps://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4

anonymous · Answer

Hey&nbsp;amitchandak&nbsp;This still doesn't seem to work, in my date table i have both Year and Month Year.Data is fetched weekly, but I don't have a "Week" column - could this be the issue?

Forum Discussion

% Change showing wrong totals

2 Replies

Related content

Total % not showing correctly

Show % change for total yoy

Adjust this measure to show totals

Total measures show wrong total when report is published

Show Measure Only in Totals in Matrix