[SOLVED] Date Filtering Malfunction in Powerview

Date Filtering Malfunction in Powerview

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";

Solution