Assume that you use Microsoft SQL Server 2012 Analysis Service (SSAS 2012) or SSAS 2014 in Unified Dimension Model (UDM) mode. When you execute a Data Analysis Expressions (DAX) query with filter on members after you have run a DAX query without any filters, the query returns incorrect result. For example: You run the following DAX query first against Adventureworks cube:
And then you run the following DAX query after the previous query:
EVALUATE ROW("Internet_Gross_Profit", 'Internet Sales'[Internet Gross Profit])
It returns the same result as the first query. This is incorrect.
"Internet_Gross_Profit", 'Internet Sales'[Internet Gross Profit]
KEEPFILTERS(VALUES('Date'[Month of Year.Key0])),
OR('Date'[Month of Year.Key0] = 9, 'Date'[Month of Year.Key0] = 8),
'Date'[Month of Year.Key0] = 5
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.