DAX Measure For Employees Regional Average

[Anonymous]

Hello,

Please I have this issue I have been trying to fix for some days now.

Say I have a table as above, the columns are Regions, Names and Total Revenue,

I want to get each employees average revenue based on their regional performance only

I need a DAX formular to get this.

Please help 

The table below shows the dataset.

Region	Names	Total Revenue
Middlesbrough	Chisom	$          5,463.00
Middlesbrough	Chizurum	$          5,866.00
Middlesbrough	Hannah	$          1,257.00
Middlesbrough	Chinaza	$          9,648.00
Middlesbrough	Ama	$          3,250.00
London	Ralph	$          4,580.00
London	John	$          7,510.00
London	Isaac	$          6,921.00
Leeds	Okechukwu	$          4,107.00
Leeds	Scott	$          1,475.00
Leeds	Phil	$          3,210.00
Leeds	Solomon	$          7,850.00
Leeds	Moses	$          1,258.00
Leeds	Smart	$          3,601.00

[Anonymous]

Thank you for the responds.

I think I missed it up. I am apparently looking for percentage performance of each employee based on regional total or regional average.

Please a DAX function for it will help clarify things for me.

Thank you

[ValtteriN · Accepted solution]

Hi,

So percentage of revenue compared to regional AVG?

In that case this should do:

Average per region =

Var Region_AVG = CALCULATE(AVERAGE(Region[Total Revenue.1]),ALL(Region[Names])) return

Divide(SELECTEDVALUE(Region[Total Revenue.1]),Region_AVG)

End result:

[ValtteriN]

Hi,

I am not completely sure what you are trying to achieve based on your problem description. Could you provide more details what is the desired end result? For now, I understood your issue so that you want to have average per region. That can be achieved by using this kind of dax:

Average per region = CALCULATE(AVERAGE(Region[Total Revenue.1]),ALL(Region[Names]))

End result: