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.
How to Calculate average of a measure(calculated field) and team member field from a table divided by number of days in DAX
Solved! Go to Solution.
I don't really understand what you try to achieve without any "example data" but you can try:
MeasureAVG= AVERAGEX (VALUES(Table[Team member]),DIVIDE(AVERAGE([Measure]),Table[Number days]),0))
I don't really understand what you try to achieve without any "example data" but you can try:
MeasureAVG= AVERAGEX (VALUES(Table[Team member]),DIVIDE(AVERAGE([Measure]),Table[Number days]),0))
User | Count |
---|---|
66 | |
46 | |
20 | |
19 | |
15 |
User | Count |
---|---|
121 | |
41 | |
38 | |
28 | |
23 |