Count many Transition from status

Questions & Answers
1

Hi

How could I bulding a formula that bring me a count of issues thar have transitions from these status:

TO DO,
REFINAMENTO DE NEGÓCIO,

PRONTO PARA REFINAMENTO COM O TIME,
REFINAMENTO COM O TIME,
PRONTO P/ DEV

I tried use this, but I think its wrong:

(([Measures].[Transitions from status issues count],
[Transition Status].[To Do], 
[Transition Status].[Refinamento de Negócio],
[Transition Status].[Pronto para refinamento com o time],
[Transition Status].[Refinamento com o time],
[Transition Status].[Pronto p/ dev]
))
2

Hi @guinevere

Try this formula in your calculated measure:

Aggregate({
[Transition Status].[To Do], 
[Transition Status].[Refinamento de Negócio],
[Transition Status].[Pronto para refinamento com o time],
[Transition Status].[Refinamento com o time],
[Transition Status].[Pronto p/ dev]
},
[Measures].[Transitions from status issues count]
)

Martins / eazyBI