Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |