Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
58 | |
29 | |
21 | |
16 |