Exclude from a filter

Questions & Answers
1

Hello, I need a measure to don’t consider a filter. Is that posible?
Here is my measure:

– annotations.drill_through_non_empty=false
Sum(
–set of days between start date 10 sprints ago an last sprint end date
[Time].[Day].DateMembersBetween(
DateWithoutTime([Measures].[Start date 10 sprints ago]),
DateWithoutTime([Measures].[Last sprint end date])
),
(
[Measures].[Issues created],
[Issue Type].[Bug],
[Sprint].CurrentHierarchy.DefaultMember)
)

and I want that to ignore a filter that I need to use: Method Found.

Thanks!

2

Hi,

You can use the Default Member of the respective dimension in the custom measure to override the filter on this dimension. This approach is already present in your formula where you generate sum regardless of the Sprint dimension filter. This line does that:

[Sprint].CurrentHierarchy.DefaultMember

You can add another line to avoid filtering by the Method Found dimension:

Sum(
–set of days between start date 10 sprints ago an last sprint end date
[Time].[Day].DateMembersBetween(
DateWithoutTime([Measures].[Start date 10 sprints ago]),
DateWithoutTime([Measures].[Last sprint end date])
),
(
[Measures].[Issues created],
[Issue Type].[Bug],
[Sprint].CurrentHierarchy.DefaultMember,
[Method Found].DefaultMember)
)

Kindly,
Janis, eazyBI support

1 Like