How to count How many Requirement Concluded per Domain

Questions & Answers
1

I am trying create one report via Excel file imported like below:

Counter| REQ Key | Domain | Status
1 | REQ-001 | Payment | Done
1 | REQ-002 | Customer | To Do
1 | REQ-003 | Billing | In Progress
1 | REQ-003 | Billing | Done

Report expected: I need to know, How many Requirement concluded per Domain . But I can consider concluded just when all REQ there are Status = Done. Like below:

Domain | REQ-DONE
Payment | 1
Customer | 0
Billing | 0 (I can´t consider DONE, because there is one REQ with Status “In Progress”

2

@ilze.leite , @lauma.cirule or @janis.plume can help me in this case?

Thanks in advance!

Zanatta

3

Hi,

The following custom measure should do that:

NonZero(Count(
  Filter(Descendants([REQ Key].CurrentMember,[REQ Key].[REQ Key]),
  [Measures].[Counter]>0 AND
  ([Measures].[Counter],
   [Status].[Done])=
           ([Measures].[Counter],
            [Status].DefaultMember)
  ))
)

Kindly,
Janis, eazyBI support

1 Like