Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 :
@Anonymous , Try with Team/Technicien
Avg_Score_department = CALCULATE(AVERAGE(Data[Score]),filter(ALLselected(Data), Data[Technicien] =max(Data[Technicien])))
@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 ?
User | Count |
---|---|
55 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
83 | |
54 | |
39 | |
21 | |
15 |