Forum Discussion

abehrmann's avatar
abehrmann
Helper II
7 years ago

Distinct count filtered Average

 I am looking to get an average of Days in ops based on distinct Request #   I tried : Ops Average Age = divide(sum(OfficeTrax[Days in OPS]),distinctcount(OfficeTrax[Request #]))   But it doesnt ...
Need Help
rafaelmpsantos's avatar
rafaelmpsantos
Responsive Resident
7 years ago

try it

measure = AVERAGEX(DISTINCT(OfficeTrax);OfficeTrax[Days in OPS])

 

If it solve, please mark as solved and give your positive feedback.

abehrmann's avatar
abehrmann
Helper II
7 years ago

rafaelmpsantos  that measure gave me the same result as if i just averaged the column [days in ops]

 

below is a samlpe of what my goal is 

 

 

Desired Result                   Sample Dataset

Request #            Days in Ops        Request #            Days in Ops

R123                     1                            R123                     1

R124                     2                            R124                     2

R125                     4                            R125                     4

R126                     7                            R123                     1

AVG:                     3.5                        R126                     7

                                                            R124                     2

                                                            AVG:      2.833333333