Forum Discussion

T-Pan's avatar
T-Pan
Icon for Helper I rankHelper I
2 years ago
Solved

Average per employee

I have the following dataset: Date       EmployeName   Operations 1/1/23.    A.                        15 1/1/23.    B.                         20 1/1/23.    C.                         7   For ...
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    Hi, T-Pan 

     

    You can try the following methods. distinct count resolved by (all activities) is a measure.

    Measure = 
Var _N1=CALCULATE(SUM('Table'[Count Operations]),ALL('Table'))
Var _table=SUMMARIZE('Table','Table'[Day],"Distinct",[distinct count resolved by (all activities )])
Var _N2=SUMX(_table,[Distinct])
RETURN
DIVIDE(_N1,_N2)

    Is this the result you expect? Please see the attached document.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
2 years ago

Hi, T-Pan 

 

You can try the following methods. distinct count resolved by (all activities) is a measure.

Measure = 
Var _N1=CALCULATE(SUM('Table'[Count Operations]),ALL('Table'))
Var _table=SUMMARIZE('Table','Table'[Day],"Distinct",[distinct count resolved by (all activities )])
Var _N2=SUMX(_table,[Distinct])
RETURN
DIVIDE(_N1,_N2)

Is this the result you expect? Please see the attached document.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

T-Pan's avatar
T-Pan
Icon for Helper I rankHelper I
2 years ago

Yes the result is the same with the measure that i create, which is the following: 

Average Activities per Distinct Analyst per Date =

DIVIDE(

SUM('All Activities Table'[Count Operations]),

SUMX(VALUES('All Activities Table'[Resolution Date Only]),

CALCULATE(DISTINCTCOUNT('All Activities Table'[Resolved By]))

)

)