Use count distinct as input to sum formula

[astitzel]

I am trying to structure a formula using both count and sum and I keep getting a nested aggregation error. I am trying to use a distinct count of ExecutionIDs as an input to a sum formula (see below).

sum(if ([Executed On.autoCalendar.Date]>=[OLFT Start], count(distinct [ExecutionId]))*[Story Points])

Is there anyway to calculate a distinct count value as an input to a larger sum formula?

[Anil_Babu_Samineni]

May be try this

Sum(if ([Executed On.autoCalendar.Date]>=[OLFT Start], count(distinct [ExecutionId])*[Story Points]))
Or
Sum(Aggr(if ([Executed On.autoCalendar.Date]>=[OLFT Start], count(distinct [ExecutionId])*[Story Points]), Dim))