Using a filter for measures in an MDX query for SSRS

Question

I created a report using a cube as a data source and an MDX query on my dataset. I have several measures in my data set, but I want to show the winners a row with at least one indicator> 0, using something like an OR filter (measure1> 0 or measure 2> 0..etc) how can I do this ?

thanks

Answer 1

Use the Filter() clause to limit the set of elements for strings:

 SELECT [Measures].[Internet Sales Amount] ON COLUMNS, Filter( [Customer].[Country].Members, ([Measures].[Internet Sales Amount] > 2000000) AND ([Measures].[Internet Sales Amount] < 5000000) ) ON ROWS FROM [Adventure Works];