Forum Discussion

titus's avatar
titus
Icon for Helper I rankHelper I
5 years ago
Solved

Average from other subgroup average

Hello,   Department Worker Days at work Units Sold Productivity (Units per day) A John 3 12 4 A Susan 5 15 3 B Angela 1 2 2 B Peter 5 20 4 B Chin 4 12 3 ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Don't @titus

    You can create a new measure to calculate the average productivity for the department.

    Measure:

    Average of Productivity(Units per day) = AVERAGEX(FILTER(Data,Data[Department]=MAX(Data[Department])),[Productivity(Units per day)])

    The result is as follows.

    1.png

    Best regards

    Rico Zhou

    If this post helps,then consider Accepting it as the solution to help other members find it faster.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    You are welcome.  If my reply helped, please mark it as Answer.