Week over week change not working

[dafbr]

Hello,

Grateful for anyone's help on this. The incident count of last week is not matching it's corresponding incident count on the line where it is the present week. For example, it starts out ok, but then as you can see, for week 33, the Count of Incident Id is 150, but then in the line for week 34, it says last week (week 33) Count of Incident Id was 129. 

Does anyone know what could be wrong?

Here are the measures:

WeekNum = WEEKNUM('queue'[First activity].[Date],1)

Count last wk = CALCULATE(DISTINCTCOUNT('queue'[Incident Id]),'queue'[WeekNum] = MAX('queue'[WeekNum])-1)

% change from last wk = DIVIDE(DISTINCTCOUNT('queue'[Incident Id])-[Count last wk],[Count last wk])

Thanks so much for any ideas.

[Sergii24 · Accepted solution]

Hi @dafbr, I'd start from referencing the same column in "WeekNum" and "Count last wk" measures. So far I see that in "WeekNum" you're referencing 'queue'[First activity].[Date] while in "Count last wk" - 'queue'[WeekNum]. Is there any particular reason for doing it?

Obviosuly, sample pbix file with dummy data and these measures would be useful to help you 🙂 

[rajendraongole1]

Hi @dafbr - adjust your measure to returns the correct count for the previous week, regardless of the row context, you can adjust the DAX measure to explicitly reference the week number

Count last wk =
CALCULATE(
DISTINCTCOUNT('queue'[Incident Id]),
FILTER(
ALL('queue'[WeekNum]),
'queue'[WeekNum] = MAX('queue'[WeekNum]) - 1
)
)

Check the above and hope it helps.