Team Average/Regional Average based on Employee Slicer section

[TS_PowerBI]

Hi all,
I'm struggling to find a solution to calculate the average for an Employees Team and Region when their employee is selected in a slicer.
I’m using remove filters right now but it’s not giving the desired results.
Here is a sample data layout.

Table Name: Employee_Master
Employee	Team	Region
1	Blue	West
2	Red	East
3	Green	West
4	Blue	East
5	Red	West
6	Green	East

Table Name: Sales_Data
Employee	Sales
1	10
2	23
3	42
4	12
5	34
6	24

Employee Master Slicer Selction = 1

Results	Value
Employee	10.0
Team Avg	11.0
Region Avg	28.7

[Anonymous · Accepted solution]

Hi @TS_PowerBI ,

Please check the model:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Washivale]

Hi @TS_PowerBI :

Consider creating below two measure to get output you have shown in screenshot

Team Average = AVERAGEX(

    KEEPFILTERS(VALUES(Employee_Master[Team])),

    CALCULATE(AVERAGE(Sales_Data[Sales]), ALL(Sales_Data[Employee])))

Region Average = AVERAGEX(

    KEEPFILTERS(VALUES(Employee_Master[Region])),

    CALCULATE(AVERAGE(Sales_Data[Sales]), ALL(Sales_Data[Employee])))

Regards,

Washivale