https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-if-function/m-p/845985#M6541 <P>Hi network<BR /><BR />I need help to create a function that allows me to generate an average measure based on the dominating direction.<BR /><BR />Exampel: if the dominatingDirection =-1, then take the average of difference<BR /><img /></P><P>The goal is to see the average value above value 0 and what is below value 0.&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Kind Regarts</P> Thu, 14 Nov 2019 09:03:49 GMT Anonymous 2019-11-14T09:03:49Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-if-function/m-p/845985#M6541 <P>Hi network<BR /><BR />I need help to create a function that allows me to generate an average measure based on the dominating direction.<BR /><BR />Exampel: if the dominatingDirection =-1, then take the average of difference<BR /><img /></P><P>The goal is to see the average value above value 0 and what is below value 0.&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Kind Regarts</P> Thu, 14 Nov 2019 09:03:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-if-function/m-p/845985#M6541 Anonymous 2019-11-14T09:03:49Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-if-function/m-p/846283#M6553 <P>There we go:</P><P>&nbsp;</P><P>Average down = CALCULATE(AVERAGE('Table'[Difference]);FILTER('Table';'Table'[DominatingDirection]=-1))</P> Thu, 14 Nov 2019 14:15:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-if-function/m-p/846283#M6553 Anonymous 2019-11-14T14:15:15Z