Need Help with Last 3 Weeks Total Calculation in Report Slicer

[HKInd]

Hi All,

Please help..!

Need help with calculating "last3WeeksTotal" based on the selected Weekending date in the slicer. The formula I provided is showing blank results:

I have applied below DAX but it showing blank result :- 

3Wkstotal =

CALCULATE(

    SUM('Date_set'[Revenue]),

    FILTER('Date_set',

    'Date_set'[Order Stage] = "Ordered"

    &&'Date_set'[Scope] = "Order"

    ),FILTER('CalendarDate','CalendarDate'[Date]>=[Selected_date]-27 && 'CalendarDate'[Date]<=[Selected_date]-7))

Report link below:

https://www.dropbox.com/s/6jvwyryae34ormg/3Weeks%20Total%20issue.pbix?dl=0 

Any suggestions or corrections are welcome!

[aj1973]

hI @HKInd 

here 3 weeks of 21 days

20 days

22 days

[HKIndia]

Please see below screenshot of what help i need, I have two columns Dates and Sale and at the bottom i have written start date of the week and end date of the week and total is 1675 from 3July to 23July when 30July Weekending date is selected. 

[HKInd]

@aj1973  Thanks for your reply, But It should work on slicer basis, If i selected date in slicer it should change date calculation accordigly. You have removed selectedvalue feature in solution.