Forum Discussion

Jarrod's avatar
Jarrod
Icon for Helper III rankHelper III
4 years ago
Solved

Measure to get Count For Employee, average count for team and average count for all employees

Hi,   I have tables as below:   Task Table Employee Task Date John A 01/01/2022 John A 02/01/2022 John A 3/01/2022 John B 1/01/2022 John B 2/01/2022 Jack A 1/0...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    You may download my PBI file from here.

    Hope this helps.

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Jarrod 

I think you mean John not Jack?

Jarrod's avatar
Jarrod
Icon for Helper III rankHelper III
4 years ago

Apologies - updated op.

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Jarrod 

    I'm having diffulties understanding how did you calculate the team average and the all average 

    • Jarrod's avatar
      Jarrod
      Icon for Helper III rankHelper III
      4 years ago

      Hi @tamerj1,

       

      John count:

       

      AA Employee Count = 3

      AA Team Average  = (3[John]+ 1[Jack]) / 2 = 2.

      AA All Average = (3 + 1 + 1)/3 = 1.666667