topic Create column containing average value for product and deviation for each row in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-column-containing-average-value-for-product-and-deviation/m-p/3102440#M156978 <P>Hi,</P><P>I have a table containing productcode and achieved price for each sale (row).</P><P>Now I want to calculate the difference from the average sale for the actual product on each row, like this:</P><TABLE border="1"><TBODY><TR><TD>Product</TD><TD>Achieved price</TD><TD>Diff from average price</TD></TR><TR><TD>A</TD><TD>50</TD><TD>-8,333</TD></TR><TR><TD>A</TD><TD>60</TD><TD>1,666</TD></TR><TR><TD>A</TD><TD>65</TD><TD>6,666</TD></TR><TR><TD>B</TD><TD>187</TD><TD>-2,500</TD></TR><TR><TD>B</TD><TD>192</TD><TD>2,500</TD></TR><TR><TD>C</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>And there are about 30000 sales and 50 products in the current table.<BR />I've tried some combinations of AVERAGE (would prefer MEDIAN though) but I just don't get how to filter on products...<BR /><BR />Anyone?<BR /><BR />Regards,</P><P>John</P> Mon, 27 Feb 2023 21:21:23 GMT jmkvalsund 2023-02-27T21:21:23Z Create column containing average value for product and deviation for each row https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-column-containing-average-value-for-product-and-deviation/m-p/3102440#M156978 <P>Hi,</P><P>I have a table containing productcode and achieved price for each sale (row).</P><P>Now I want to calculate the difference from the average sale for the actual product on each row, like this:</P><TABLE border="1"><TBODY><TR><TD>Product</TD><TD>Achieved price</TD><TD>Diff from average price</TD></TR><TR><TD>A</TD><TD>50</TD><TD>-8,333</TD></TR><TR><TD>A</TD><TD>60</TD><TD>1,666</TD></TR><TR><TD>A</TD><TD>65</TD><TD>6,666</TD></TR><TR><TD>B</TD><TD>187</TD><TD>-2,500</TD></TR><TR><TD>B</TD><TD>192</TD><TD>2,500</TD></TR><TR><TD>C</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>And there are about 30000 sales and 50 products in the current table.<BR />I've tried some combinations of AVERAGE (would prefer MEDIAN though) but I just don't get how to filter on products...<BR /><BR />Anyone?<BR /><BR />Regards,</P><P>John</P> Mon, 27 Feb 2023 21:21:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-column-containing-average-value-for-product-and-deviation/m-p/3102440#M156978 jmkvalsund 2023-02-27T21:21:23Z Re: Create column containing average value for product and deviation for each row https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-column-containing-average-value-for-product-and-deviation/m-p/4007606#M156988 <P>Hi,</P><P>&nbsp;</P><P>The information provided is incomplete. please try to give full context and input data and expected output along with calculation logic. this will help anyone to provide the solution.</P> Mon, 24 Jun 2024 18:54:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-column-containing-average-value-for-product-and-deviation/m-p/4007606#M156988 Ankur04 2024-06-24T18:54:20Z