How to calculate average of simple column

[Anonymous]

Hi Team,

I've got a column that contains all the phone calls taken by agents for the month. I would like to create a column caled 'Average' which calculates the average percentage of calls taken by each agents.

Ideally the formula would be total queue call taken by agent / total number of queue calls taken by all agents

However, when I use the Average DAX function in power BI, it return the same value (see image below)

Please advise what I'm doing wrong.

My column is not calculating the Average properly

Assuming the total number of calls is 2880, the result I want is:

[Anonymous]

Thank you so much @Seanan That has resolved the issue.

Thanks to everyone who tried to help in this post as well. I never knew I'd be receving this great help. 🏆

[Anonymous]

Sorry guys, would you know why the SubAvg changes all to 100% when I try to add another column into this visual.

[tamerj1]

@Anonymous 

Which column from which table?

[Anonymous]

Any of the columns highlighted in red basically changes the SubAvg into 100%. 

[tamerj1]

@Anonymous 

Once you add any column to a table or matrix visual it becomes part of the filter context. In this case it is not wise to keep changing the total measure formula to adapt with every column you add. Therefore it is recommended to use only one column for slicing (Agent) and add other columns only as measures. For example SUM ( [Count] ) or SELECTEVALUE ( [Net Login] )

[Anonymous]

Here's link to the file: https://1drv.ms/u/s!AnEZNSVeMtRbjnPHx_ai1uxa3-TR?e=Mj22Lz

[tamerj1]

@Anonymous 
Sorry I just saw your reply and I noticed that you are slicing by a column from the fact table.

Here is the file https://we.tl/t-Y0Ffz8gEKD

Please try allways to slice by columns from dim tables  oly as fact tables cannot filter dim tables and you'll be in trouble. Here is a screenshot of the table visual with all required columns added. Only a small fix by replacing the fact [Agent] column with dim [Agent Name] column. The same is reflected on the formiula of the measure [Total] (As per my pervious reply to the original query of this post).

[Surya9]

@Anonymous This is working for me try this

Average =

var a = CALCULATE(SUM('Table (2)'[call]),all('Table (2)'))

return DIVIDE(

SUM('Table (2)'[call]),

a)

[Surya9]

@Anonymous 
Create a measure that will give you the expected output

[Surya9]

@Anonymous you are looking for the % of call taken by the user 
i think this will help you try the below measure

Average =

var a = CALCULATE(SUM('Table (2)'[call]),REMOVEFILTERS('Table (2)'[name]))

return DIVIDE(

SUM('Table (2)'[call]),

a)

you can also use All Insted of Removefilter