DATEADD problem with Slicers

[jfmejiav1]

Hello Currently im trying to get a WoW measure for the total of deals with a new flag created. below you will see the formula.

Deals With Flag = CALCULATE(DISTINCTCOUNT('Deals With Flag'[Deal iD]),FILTER('Deals With Flag','Deals With Flag'[Flag]=1))

Last Week = CALCULATE('Deals With Flag'[Deals With Flag],DATEADD('Snapshot Calendar'[Week Date],-7,DAY))

then

WoW variance = [Deals With Flag]-[Last Week]

Currently this measure works but then i put it in a Graph and also I want to show in a table the new deals that were created for that specific week. when i click the bar for a specific week the table wont filter those specific deals.

How can i make it work?

[kcantor]

@jfmejiav1 

Can you share a snapshot of your data model, relationships, and, most importantly, your date table? If you are not using a separate date table with all dates, it will not work appropriately.

[jfmejiav1]

Hello,

Thank you for the response 

As for your comment i do use an independent date mapping.

also here is a link to see the PBIX https://db.tt/BlPVDoacwF

@kcantor