Forum Discussion

jfmejiav1's avatar
jfmejiav1
Frequent Visitor
7 years ago

DATEADD problem with Slicers

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?
Need Help

2 Replies

  • kcantor's avatar
    kcantor
    Community Champion
    7 years ago

    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.