Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
harshagraj
Post Partisan
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])
harshagraj_0-1643615567108.png

Please help @amitchandak @parry2k 

 
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@harshagraj ,

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

 

or

 

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

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@harshagraj ,

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

 

or

 

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.