DAX: "Sales $ Last Year to Date" is wrong if no date is selected

[Anonymous]

Hi DAX experts,

For "Sales $ Last year to date" measure, my requirement is that if no date is selected/filtered, the period of calculating "Sales $ LYTD" is from beginning of previous year to yesterday's date of previous year. e.g: today is 6th Sep; the perios is from 2016-01-01 to 2016-09-05. My DAX is as followings. I use isfiltered function to check if date is filtered and use different calculation to calculate Sales $ LYTD. It worked fine before. After we removed some data from fact table, full process the tabular cube and the "Sales $ LYTD" become wrong.

Sales $ LYTD:=

var yesterday= CALCULATE(max('Date'[Date]),filter(all('Date'),'Date'[Day Offset]=0))

if(ISFILTERED('Date'[Year]) || ISFILTERED('Date'[Month Desc]) || ISFILTERED('Date'[Day Desc]),
        CALCULATE([Sales $],dateadd(DATESYTD('Date'[Date]),-1,YEAR)),

        CALCULATE(
               [Sales $],
               filter(
                     all('Date'),
                     'Date'[Year]=year(yesterday)-1 && 'Date'[Month Number]<=month(yesterday) && 'Date'[Day Number]<=day(yesterday)
                     )
        )
  )

if I filter on date and select a date 2017-09-05, it works perfectly. see below screenshot:

If I don't filter on the date, it is wrong. See below screenshot:

if I break down the data slicing by region dim, I found subtotal on region level is wrong, the grandtotal just the sum of subtotal, which is wrong either.

if I break down the year, the grand total is wrong:

note: I have debugged my filter "'Date'[Year]=year(yesterday)-1 && 'Date'[Month Number]<=month(yesterday) && 'Date'[Day Number]<=day(yesterday)", it is as expected. 

Can you please advise the root cause and what is further troubleshoting steps I can do? Thank you.

[Anonymous · Accepted solution]

I have found the root cause by myself. My below condition has logic mistake to get correct period. issue resolved now

'Date'[Year]=year(yesterday)-1 && 'Date'[Month Number]<=month(yesterday) && 'Date'[Day Number]<=day(yesterday)

[Amardeep100115]

could you please share above PBIX file