Search code examples
visual-studiot-sqlreporting-servicesssasmdx

Filter out a member from SSRS (MDX)

Ok, So I have a dim called Employee that has Employee_ID and the ID I am trying to filter out from the report table is &[12345].

How would I go about filtering out a record for just that employee ID from my report table?

Solution

  • You can use the Except function:

    Except('a set that contains employees', {'the employee you want to exclude'})