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.