Forum Discussion

atowriss1's avatar
atowriss1
Advocate I
3 years ago

Filter Issue- Filter not working

Hi,   I am trying to get # of stores in our pipleline for the next month that have an estimated monthly revenue of 2K or greater.   Below is the Dax:   test = VAR _medate=selectedvalue(dimDate...
Need Help
sevenhills's avatar
sevenhills
Super User
3 years ago

 

 

Try 1:

Test = 
VAR _medate = selectedvalue(dimDate[Date]) -- Not sure what is the use of this one, as no further reference
VAR _numberofmonth = 1 -- Not sure what is the use of this one, as no further reference
RETURN 
     CALCULATE ( 
         SUM ('EC Closed Report'[# of Rooftops]),
         USERELATIONSHIP('EC Closed Report'[Exp Revenue Month Date], dimDate[Date]),
         FILTER( ALL('EC Closed Report'), [Closed Rev] >= 2000)
         --,
         -- Not sure what this is doing here?
         -- DATEADD(dimDate[Date].[Date],+1,MONTH)
)

 

 

 

See if this portion of DAX works ... 

atowriss1's avatar
atowriss1
Advocate I
3 years ago

Without the date add it works, but returns stores with expected revenue in November, and I need expected revenue for December, which is why I had the DateAdd.  I tried putting the DateAdd after the filter, but that didn't work either.