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.
Here are the steps to reproduce the problem.
1.) Unzip the files into the [MyDocs]\GrapeCity\ActiveAnalysis\DataSources\*.* directory.
2.) Run the WinViewer sample that ships with ActiveAnalysis setup.
3.) Click on 'Data' menu item and choose 'Connect to DataSource...'
4.) Select the new 'Northwind (Sales)' connection.
4.) Drop [Orders].[OrderID] on Row shelf
5.) Drop [Product].[Product Name] attribute to the right of [Orders].[OrderID] on Row shelf
6.) Drop the following measures on the Data shelf
7.) Move [Measures].[MeasureNames] on Column shelf to make the display look readable.
-- NOTE: Your display should be similar to the First.jpg screenshot
8.) Now, apply a Measure filter to only show members where [Measures].[Margin] is between $100 - $500
- Display the [Measures].[Margin] dropdown
- Select 'Show quick filter'
- Set the low value to 100
- Set the high value to 500
-- NOTE: Your display should be similar to the Second.jpg screenshot
I would expect that the display would display all records where the Margin value is between $100 and $500. :P
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.