Forum Discussion
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 ...
try it
measure = AVERAGEX(DISTINCT(OfficeTrax);OfficeTrax[Days in OPS])
If it solve, please mark as solved and give your positive feedback.
I have been working on several replies only to find that you had already answered them. Great work!
P.S. Your solutions are more elegant than mine anyway! :smileyhappy:
Thanks Christann, i have big difficulties with english, i'm brazilian, but i try to help.