https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Average-in-DAX/m-p/3343295#M125498 <P>I don't really understand what you try to achieve without any "example data" but you can try:<BR /><BR /></P><LI-CODE lang="markup">MeasureAVG= AVERAGEX (VALUES(Table[Team member]),DIVIDE(AVERAGE([Measure]),Table[Number days]),0))</LI-CODE><P><BR /><BR /><BR /></P> Fri, 21 Jul 2023 12:07:49 GMT mlsx4 2023-07-21T12:07:49Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Average-in-DAX/m-p/3342033#M125459 <P>How to Calculate average of a measure(calculated field) and team member field from a table divided by number of days in DAX</P> Fri, 21 Jul 2023 00:56:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Average-in-DAX/m-p/3342033#M125459 Anonymous 2023-07-21T00:56:40Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Average-in-DAX/m-p/3343295#M125498 <P>I don't really understand what you try to achieve without any "example data" but you can try:<BR /><BR /></P><LI-CODE lang="markup">MeasureAVG= AVERAGEX (VALUES(Table[Team member]),DIVIDE(AVERAGE([Measure]),Table[Number days]),0))</LI-CODE><P><BR /><BR /><BR /></P> Fri, 21 Jul 2023 12:07:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Average-in-DAX/m-p/3343295#M125498 mlsx4 2023-07-21T12:07:49Z