How to except some members

Questions & Answers
1

Hi Communities,

I am trying to use the MDX script below to except some members of set , just like this:

Aggregate(
Except(
[Products].[Products].Members,
{[Products].[A], [Products].[B]
}
)
)

But some users with multi-products connection still in the list, for example User “X” belongs Product A, B, C.

We also want to exclude this type user (User X), any good ideas or suggestions?

Thanks in advance.

2

A non-MDX approach could be using filter. If you are able to add [Measure].[Issue Product] column showing comma separated products. You can right click the column to apply filter that use regex to exclude anything contains certain product.

3

Hi @Newbyhehe

Thanks for posting your question!
If you have Products added in the report as property, you could filter the report by Row filter "not matches “.A.|.*B.”, similarly as in the screenshot below where I’ve filtered the Labels row.

image
image1004×368 28.1 KB

If you don’t have the product added in the report , try defining a new calculated measure in the Measures dimension with the formula below and see if it returns the expected results?

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    IsEmpty(([Measures].[Issues created],
    [Products].[A])) AND
    IsEmpty(([Measures].[Issues created],
    [Products].[B])) 
  ),
  [Measures].[Issues created]
)

Best wishes,

Elita from support@eazybi.com

4

Hi Elita,
I have a similar issue and my Custom field Channels Impacted (JPDD) is in my report as a column however, I don’t see how to remove some of the context items from the report.
I tried Search adn bookmark to get them individually listed but that doesn’t allow me to select only certain ones to display either.
What can I do to sort this?