Create a calculated member based on 2 fields - status and label

Questions & Answers
1

Hello,

I have created a report to get the numbers of issues created by status. It works fine.
I would like to add a column for one of the status (Waiting for R&D) to get the number of issues created when the status = Waiting for R&D and label = “TEST”.
I’m struggling how to define the calculated members.
if you have some ideas to share, they will be welcome.

Thanks,

2

Would this be your case?
Going to “Measures” and then “Define new calculated measure”. Providing a name and inside it, creating a tupla with these 3 elements

(
  [Measures].[Issues created],
  [Status].[Waiting for R&D],
  [Label].[TEST]
)
3

Thanks for your reply, I have used another option : create a new calculated member on the label field. So I have the number of tickets for this status and also the number of tickets for this status when the label = TEST.

4

Hi Sylvie,
I agree with Nacho’s recomendation - the best way forward is to create a calculated measure.
Is your option working as expected or do you still have any open questions?

Best,
Ilze