You are on the right track, but as eazyBI takes each label separately with the measures, we will also need to create a calculation in Measures dimension. Please do the following:
In label dimension create calculated measure with labels you wish to exclude:
In Measures, create and use a calculated member that will subtract the issues with any of the labels from total (using the measure from the previous step)
NonZero([Measures].[Issues due] -
(
[Measures].[Issues due count],
[Label].[Labels to except]
))
Let me know if I missed something and you have some further questions!
Lauma / support@eazybi.com
In row I display all my labels about teams, plus ‘All Labels’.
My calculation in Measures dimension is:
CASE [Label].CurrentMember.Name
WHEN "All Labels" THEN
NonZero(
[Measures].[Issues created count]
-
([Measures].[Issues created count],[Label].[TeamsLabels])
)
ELSE
NonZero([Measures].[Issues created count])
END