Posted 3 August 2017, 3:57 pm ESTWhenever we try to filter on a calculated measure, the results are never predictable. We've been able to reproduce the problem pretty consistently and can't find a suitable work around. Basically, we would expect that when applying a measure filter against a calculated measure would exclude all values that don't fall within that range. This concept holds true for non-calculated measures, but not for calculated measures.
<br />Here are the steps to reproduce the problem.
<br />1.) Unzip the files into the [MyDocs]\GrapeCity\ActiveAnalysis\DataSources\*.* directory.
<br />2.) Run the WinViewer sample that ships with ActiveAnalysis setup.
<br />3.) Click on 'Data' menu item and choose 'Connect to DataSource...'
<br />4.) Select the new 'Northwind (Sales)' connection.
<br />4.) Drop [Orders].[OrderID] on Row shelf
<br />5.) Drop [Product].[Product Name] attribute to the right of [Orders].[OrderID] on Row shelf
<br />6.) Drop the following measures on the Data shelf
<br /> - [Measures].[UnitPrice]
<br /> - [Measures].[Quantity]
<br /> - [Measures].[SalesAmount]
<br /> - [Measures].[Discount]
<br /> - [Measures].[Margin]
<br />7.) Move [Measures].[MeasureNames] on Column shelf to make the display look readable.
<br /> -- NOTE: Your display should be similar to the First.jpg screenshot
<br />8.) Now, apply a Measure filter to only show members where [Measures].[Margin] is between $100 - $500
<br /> - Display the [Measures].[Margin] dropdown
<br /> - Select 'Show quick filter'
<br /> - Set the low value to 100
<br /> - Set the high value to 500
<br /> -- NOTE: Your display should be similar to the Second.jpg screenshot
<br />I would expect that the display would display all records where the Margin value is between $100 and $500. :P
<br />BONUS: You can see that this works as expected if you apply a quick filter on 'UnitPrice' (10 - 20), or any other NON-CALCULATED measure.