cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Create Index Average - Divide row value by total of column

I am trying to create a measure that will give me an index average on each row.

Beside the "NewAverage" I need a measure named as "Productivity" that will divide each row to the column total value. By using the "NewAverage", the first row would essentially have an index average of 1.62 (5.78/3.57) the second row would have an index average of 1.42 (5.09/3.57).

 

 

 

five.PNG

Below are some reference:

Request Completed = COUNTROWS(TblNewSLATEST)

 

Number of days = DISTINCTCOUNT(TblNewSLATEST[Month&Day])

 

Average Completed Request per day = DIVIDE([Request Completed], [Number of days])

 

NewAverage = AVERAGEX(SUMMARIZE(TblNewSLATEST, TblNewSLATEST[EmployeeName], "toAverage", [Request Completed]), [Average Completed Request per day])

 

 

I hope someone could help me...

Thank you so much in advance!

1 REPLY 1
KMW Helper I
Helper I

Re: Create Index Average - Divide row value by total of column

Is it possible for you to attach the datafile for your created visual?

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors