cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Post Partisan

## Average of Average measure

Hello all i have 3 measures DF%,CS%,PPAP% and for each team members snapshotted on every month end.

Please see the attached image. So for the above 3 measures i am taking average of all the three by the measure

Average =
Var a = IF([DF%]="NA",0,1)
Var b = IF([CS%]="NA",0,1)
Var c = IF([PPAP%]="NA",0,1)
Var d = [CS1%]+[DF1%]+[PPAP1%]
Var e = a+b+c
Return
d/e
The above Average measures works fine. But now i need to display Average of average for each team members.
Eg Team member 1 28th Oct 2021--100% and 25th Nov 2021--100% and 30th Dec 2021--88.89% Then the Average of average should be 96.29%
And i have used below measure but the result is wrong
AVERAGEX(
VALUES('projects'[snap_date]),[Average])

1 ACCEPTED SOLUTION
Super User

AVERAGEX(
VALUES('projects'[Team Member name]),[Average])

or

AVERAGEX(addcolumns( Summarize('Project', 'projects'[snap_date], 'projects'[team member name]), "_1",[Average]), [_1])

Super User

AVERAGEX(
VALUES('projects'[Team Member name]),[Average])

or

AVERAGEX(addcolumns( Summarize('Project', 'projects'[snap_date], 'projects'[team member name]), "_1",[Average]), [_1])

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors