Week over week change based on applied filters

[Anonymous]

I'm trying to calculate my outstanding AR WOW change. Which is working using following DAX formula

To store previous week Amount

WOW0_30 =

VAR CurrentWeek = SELECTEDVALUE('AR DATA SET (2)'[WeekNumber])

VAR CurrentYear = SELECTEDVALUE('AR DATA SET (2)'[Year])

VAR MaxWeekNumber = CALCULATE(MAX('AR DATA SET (2)'[WeekNumber]), ALL('AR DATA SET (2)'[Cash Date]))

RETURN

SUMX(

FILTER(ALL('AR DATA SET (2)'),

IF(CurrentWeek = 1,

'AR DATA SET (2)'[WeekNumber]= MaxWeekNumber && 'AR DATA SET (2)'[Year] = CurrentYear - 1,

'AR DATA SET (2)'[WeekNumber] = CurrentWeek - 1 && 'AR DATA SET (2)'[Year] = CurrentYear)),

[0_30])

To calculate Difference

Change0_30 = [0_30]-[WOW0_30]

If I apply different Filters like payer, business location. the formula wont calculate based on applied filters and will deduct based on Total AR sum

 

the varience will be calculated with respect to Total AR.

How can I fix this problem

[amitchandak]

@Anonymous , for WOW analysis refer my blogs

https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123

https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3