https://community.fabric.microsoft.com/t5/Developer/Error-message-in-DAX-while-using-Summarize/m-p/4355318#M58932 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/497882">@smishra99acres</a>&nbsp;</P><P>&nbsp;</P><P>The Summarize function creates a table.</P><P>You cannot use it by itself in a measure.</P><P>&nbsp;</P><P>Use New Table to create a table using the summarize function:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SamWiseOwl_0-1736343376993.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1223508i8ABD0C2D32DA2C3A/image-size/medium?v=v2&amp;px=400" role="button" title="SamWiseOwl_0-1736343376993.png" alt="SamWiseOwl_0-1736343376993.png" /></span></P><P>&nbsp;</P><P>If you want to use it in a measure, you need to do something with the table.</P><P>AggregateX functions like MaxX, AverageX and SumX let you aggregate the rows of data.</P><P>&nbsp;</P><P>Here for example I am using Summarize to calculate for each Quantity what the Sum of Price is.</P><P>Then using AggergateX to return the overall average.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SamWiseOwl_1-1736343496672.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1223510i8792DCAA5243418A/image-size/medium?v=v2&amp;px=400" role="button" title="SamWiseOwl_1-1736343496672.png" alt="SamWiseOwl_1-1736343496672.png" /></span></P><P>&nbsp;</P> Wed, 08 Jan 2025 13:38:50 GMT SamWiseOwl 2025-01-08T13:38:50Z https://community.fabric.microsoft.com/t5/Developer/Error-message-in-DAX-while-using-Summarize/m-p/4354845#M58929 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="smishra99acres_0-1736328221631.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1223388i2C2C13D8EDBAF8C9/image-size/medium?v=v2&amp;px=400" role="button" title="smishra99acres_0-1736328221631.png" alt="smishra99acres_0-1736328221631.png" /></span></P><P>&nbsp;</P> Wed, 08 Jan 2025 09:25:33 GMT https://community.fabric.microsoft.com/t5/Developer/Error-message-in-DAX-while-using-Summarize/m-p/4354845#M58929 smishra99acres 2025-01-08T09:25:33Z https://community.fabric.microsoft.com/t5/Developer/Error-message-in-DAX-while-using-Summarize/m-p/4355318#M58932 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/497882">@smishra99acres</a>&nbsp;</P><P>&nbsp;</P><P>The Summarize function creates a table.</P><P>You cannot use it by itself in a measure.</P><P>&nbsp;</P><P>Use New Table to create a table using the summarize function:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SamWiseOwl_0-1736343376993.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1223508i8ABD0C2D32DA2C3A/image-size/medium?v=v2&amp;px=400" role="button" title="SamWiseOwl_0-1736343376993.png" alt="SamWiseOwl_0-1736343376993.png" /></span></P><P>&nbsp;</P><P>If you want to use it in a measure, you need to do something with the table.</P><P>AggregateX functions like MaxX, AverageX and SumX let you aggregate the rows of data.</P><P>&nbsp;</P><P>Here for example I am using Summarize to calculate for each Quantity what the Sum of Price is.</P><P>Then using AggergateX to return the overall average.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SamWiseOwl_1-1736343496672.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1223510i8792DCAA5243418A/image-size/medium?v=v2&amp;px=400" role="button" title="SamWiseOwl_1-1736343496672.png" alt="SamWiseOwl_1-1736343496672.png" /></span></P><P>&nbsp;</P> Wed, 08 Jan 2025 13:38:50 GMT https://community.fabric.microsoft.com/t5/Developer/Error-message-in-DAX-while-using-Summarize/m-p/4355318#M58932 SamWiseOwl 2025-01-08T13:38:50Z