Labels and issuetypes - calculated

I am trying to create a calculated member that consists of issues types that have a particular label.
In this case techdebt. In the end I will have 3 calculated members - stories created by product, stories created by dev (techdebt) and bugs.

I can’t figure out how to create the calculated member for stories with techdebt label- which is actually and aggregate of several variations of techdebt.)

any help would be appreciated.


The recommended solution for this use case is to use the tuples in the formulas:

The number of bugs:

([Measures].[Issues created],
[Issue Type].[Bug])

The number of stories with specific labels:

([Measures].[Issues created],
[Issue Type].[Story],

You can also create an aggregated member in the Label dimension as described here and refer to them in tuples if several labels must be covered in the calculation:

As the Label is the multiple value dimension, you may wish to use the distinct count of issues:

([Measures].[Issues created count],
 [Issue Type].[Story],