How to if condition ,if ageing > 45 days then select fields

Questions & Answers
1

How to if condition ,if ageing > 45 days then select fields
case WHEN [Measures].[Ageing created]>45
THEN
NonZero(
Count(Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
(DateDiffWorkdays(
(
[Measures].[Incident Reported Date]
)
,
(
[Measures].[Transition to status first date],
[Transition Status].[Requirement Complete]
)
)>10)
)))
END

2

Hi @madhuri

Your formula is almost correct, the only slight adjustment needs to be made where you move the case statement into the filter part as well.

Here is an adjusted formula:

NonZero(
Count(
  Filter(
   Descendants([Issue].CurrentMember, [Issue].[Issue]),
   [Measures].[Ageing created] > 45 AND
   DateDiffWorkdays([Measures].[Incident Reported Date],
   ([Measures].[Transition to status first date],
   [Transition Status].[Requirement Complete])
   )>10
  )
))

Best wishes,

Elita from support@eazybi.com