Using Filter on measures in MDX query on SSRS

6
votes

i've creted a report using a cube as datasource and MDX query on my dataset. i have a few measures in my dataset but i want to show wonly the rows with at least one of the measures > 0, using something like an OR filter (measure1 >0 or measure 2 >0 ..etc) how can i do this?

thanks

1
reporting-servicesfiltermdxcubemeasure

1 Answers

5
votes

Use the Filter() clause to constrain the memberset for the rows:

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