Date Filtering Malfunction in Powerview

Question

I am building a reporting solution using Powerview on Sharepoint Server 2013 with ssas multidimensional data source.

On the powerview reports I have encountered a strange problem. When I filter using a date attribute with multiple values only the non calculated facts (simple measures, not mdx) are being filtered, while for single date selection everything is filtered correctly.

The strange thing is that in the cube browser everything works fine for all facts and all dates selections.

Any idea would be highly appreciated.

Thanks!

Sample Calculations :

CREATE MEMBER CURRENTCUBE.Measures.NewRequestsCount
as

aggregate({[DM RMS Workflow Actions].[Standard Action FK].&[13],[DM RMS Workflow Actions].[Standard Action FK].&[1]},[Measures].[FC RMS Request Actions Count]),
ASSOCIATED_MEASURE_GROUP='FC RMS Request Actions',format_string="#,##0";

and

CREATE MEMBER CURRENTCUBE.Measures.ForwardsCount
as

aggregate(([DM RMS Workflow Actions].[SN].&[62],[DM RMS Is Fake].[Value].&[Real]),[Measures].[FC RMS Request Actions Count]),
ASSOCIATED_MEASURE_GROUP='FC RMS Request Actions',format_string="#,##0";

I just noticed that the behavior is the same for every filter not only the date filters. If I choose multiple values then the calculation is shown for all values. — Andreas Dest
What is the calculation behind [Measures].[FC RMS Request Actions Count]? Or if it's a physical measure what's the AggregateFunction? If you change Aggregate() to Sum() do you have the same problem? — GregGalloway
It is the default count of the measure group. Nothing changes if I use sum. The filters work fine in excel pivot tables also...It must be a Power View related problem — Andreas Dest

Andreas Dest Andreas Dest · Accepted Answer · 2015-11-25T12:00:29

Finally I found a solution.

The problem was solved by installing Sql Server 2012 sp3

https://www.microsoft.com/en-us/download/details.aspx?id=49996.

Date Filtering Malfunction in Powerview

1 Answers