Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hallo,
i would like to create a graph that will display the following data from an evaluation app only for completed evaluations.
the number of employees by employee type that were evaluated above average score. (max 100%)
There is a secondary list for employees with a column called Position (lookup to Positions list)
the main list has all the evaluation data columns (uniqueId, employeeName, Score, Year, status)
i am not sure how and which would be the appropriate visual.
Any ideas ?
@marial16 , Based on what I got
AverageX(Values(Table[uniqueId]), calculate(Sum(Table[Score])) )
or
AverageX(Values(Table[Year]), calculate(Sum(Table[Score])) )
or
AverageX(Summarize(Table, Table[uniqueId], Table[Year]), calculate(Sum(Table[Score])) )
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |