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.
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])) )
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
84 | |
84 | |
66 | |
63 | |
62 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |