Creating an average

[Anonymous]

Hi,

I have a list of percentages for people in diofferent departments like below:

 and I would like to build a measure to find the average Billing target % for each department:

for example for the table above I am looking for:-

sum of billing target % (627%)

/ number of people in the client dept (7 people)

= 89.57%

I have tried doing this in a measure but cannot seem to get this to work?

Can anybody help with the best way to do this?   

Many thanks,

[v-piga-msft · Accepted solution]

Hi  @Anonymous ,

For your requirement, please refer to this measure.

Measure =
CALCULATE (
    AVERAGE ( 'Table 2'[Billing Target] ),
    ALLEXCEPT ( 'Table 2', 'Table 2'[Department], 'Table 2'[Name] )
)

Here is the output.

Best Regards,

Cherry

[Anonymous]

Hi,

Please try with below DAX code.

Average % = AVERAGEX(FILTER(Table1,Table1[Department]="Client"),Table1[Billing Target])

[HotChilli]

The simplest way is to drag 'Department' on to a table.

Then drag 'Billing Target' next to it and choose 'Average' in the dropdown on the Values field well.