Different measures show the same results when report is published

[sgroth001]

I have a report with several measures that calculate scans on different date ranges and show different results.

Desktop report

When I publish the report, the measures all show the same value -- and it's not even the right value!

Published report

The report uses direct query for incremental refresh and real-time data, so there is more data in the published report.  However, none of the Prior Year (PY) stats should be any different, and they definitely shouldn't all be the same. 

I don't think this matters because variables only exist within the calculation of a measure, but just in case, I'll share that each of the measures follow similar constructs and use the same variable names.  For example

PY2 WY Scan Units =

VAR TodayDate = Today()

VAR TodayYear = year(TodayDate)

VAR StartDate = calculate(min('Date'[Date]),'Date'[Calendar Year]=TodayYear - 2)

VAR EndDate = calculate(max('Date'[Date]),'Date'[Calendar Year]=TodayYear - 2)

Return calculate([Scan Units],datesbetween('Date'[Date],StartDate,EndDate))

and

PY WY Scan Units =

VAR TodayDate = Today()

VAR TodayYear = year(TodayDate)

VAR StartDate = calculate(min('Date'[Date]),'Date'[Calendar Year]=TodayYear - 1)

VAR EndDate = calculate(max('Date'[Date]),'Date'[Calendar Year]=TodayYear - 1)

Return calculate([Scan Units],datesbetween('Date'[Date],StartDate,EndDate))

I appreciate any help on fixing this bug.

[sgroth001 · Accepted solution]

I found my mistake.  I had set the incremental refresh parameters to exclude all the data that would have been captured in the measures.

That's not going to include any prior-year data.

[sgroth001]

If I take out the incremental refresh, the published report renders correctly.

[amitchandak]

@sgroth001 , Clear Browser cache -> Refresh and try

or

Republish -> Clear Browser cache -> Refresh and try 

[sgroth001]

@amitchandak   Thanks for your reply.  Clearing the cache and republishing didn't work.  The values are still repeated across different measures.  Interestingly, different values are now being repeated, but it's still the same problem.

To offer a little more context, the report showing duplicated values across measures is my "Golden Dataset" that I'm using as the data source for another report.  That report also shows the duplicated values.