Forum Discussion

setis's avatar
setis
Post Partisan
6 years ago

Ignoring a filter

Dear experts, I am trying to create a measure to show me the sales amount per month for all years except 2009 (in my real project will be "current year" but for this excercise this can work)   My ...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Are you trying to get Avg no cases per day ??

amitchandak's avatar
amitchandak
Super User
6 years ago

then try something like that

Avg Sales NO Day = 
var _year = SELECTEDVALUE('Date'[Year])
return
CALCULATE (
    Sales[# Sales],ALL('Date'[Year]),not('Date'[Year] =_year)
)/CALCULATE (
    count('Date'[Date]),ALL('Date'[Year]),not('Date'[Year] =_year)
)
  • setis's avatar
    setis
    Post Partisan
    6 years ago

    Dear amitchandak 

     

    Thanks a lot for your effort. I am still getting blanks with this one. 

     

    I'll try to reproduce the issue with a dummy report and post it here.