Average of a group in a line chart

[Anonymous]

Hello,

I'm trying to display 3 things  on a line chart:

- average asked score  ( a constant )     - Done

- average score of someone  - Done

- average score of the someone 's team   - issue

Here are my data

there are several Departments , with several teams , with several technicians.

I'd like to display my result in a line chart like this. A filter allow me to choose a Department , then a team , then a technician

I tried the following Dax formula : 

Avg_Score_department = CALCULATE(AVERAGE(Data[Score]),ALL(Data[Technicien])) 

thinking it would keep all technician from selected team ... it works fine until I choose a technician ( despite ALL statement ) , then I can't explain the result ...

I also tried " ALLEXEPT" statement but it return a constant ..

Team is in " SILAE" table , I also tried  to add a team column in "DATA" table but it returns the same result ..

Anybody has a lead ?  

[amitchandak]

@Anonymous , Try with Team/Technicien

Avg_Score_department = CALCULATE(AVERAGE(Data[Score]),filter(ALLselected(Data), Data[Technicien] =max(Data[Technicien])))

[Anonymous]

@amitchandak  Hello and thanks for your fast anwser 😊

unfortunately , it's not working since it shows a constant ( same result with Team/ Technician ) ...

I 'd like it to be calculated per month , may be I should use AVERAGEX  ?