The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |