topic Re: SUM of measure with filter in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUM-of-measure-with-filter/m-p/3107269#M109600 <P>hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="460868" data-lia-user-login="FreemanZ" class="lia-mention lia-mention-user">FreemanZ</a>&nbsp;</P><P>&nbsp;</P><P>thanks for following up</P><P>my table looks in real as follows&nbsp;</P><P><img /></P><P>&nbsp;</P><P>the measure is</P><DIV><DIV><SPAN>Moyenne de Prod annuelle par LIGNE = </SPAN></DIV><DIV><SPAN>AVERAGEX</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>KEEPFILTERS</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>'Parc Machines'</SPAN><SPAN>[LIGNE]</SPAN><SPAN>)),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>AVERAGE</SPAN><SPAN>(</SPAN><SPAN>'Parc Machines'</SPAN><SPAN>[Prod annuelle]</SPAN><SPAN>))</SPAN></DIV><DIV><SPAN>)</SPAN></DIV></DIV><P>&nbsp;</P><P>I need to have a measure which is the subtotal per customer.</P><P>&nbsp;</P><P>does that make sense?</P><P>&nbsp;</P> Thu, 02 Mar 2023 07:28:29 GMT DAVID_DART 2023-03-02T07:28:29Z SUM of measure with filter https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUM-of-measure-with-filter/m-p/3105589#M109400 <P>Hello</P><P>&nbsp;</P><P>I would like to manage the sum of the measure (being the result of the line) depending on the customer</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>CUSTOMER</TD><TD>LINE</TD><TD>MEASURE</TD></TR><TR><TD>A</TD><TD>1</TD><TD>10</TD></TR><TR><TD>A</TD><TD>2</TD><TD>20</TD></TR><TR><TD>B</TD><TD>1</TD><TD>15</TD></TR><TR><TD>B</TD><TD>2</TD><TD>30</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>thanks for your help</P> Wed, 01 Mar 2023 09:32:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUM-of-measure-with-filter/m-p/3105589#M109400 DAVID_DART 2023-03-01T09:32:00Z Re: SUM of measure with filter https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUM-of-measure-with-filter/m-p/3105625#M109411 <P>I specify more... I want to generate a new measure to have a table as follows</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>CUSTOMER</TD><TD>SUM OF MEASURE</TD></TR><TR><TD>A</TD><TD>30</TD></TR><TR><TD>B</TD><TD>45</TD></TR></TBODY></TABLE> Wed, 01 Mar 2023 09:50:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUM-of-measure-with-filter/m-p/3105625#M109411 DAVID_DART 2023-03-01T09:50:33Z Re: SUM of measure with filter https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUM-of-measure-with-filter/m-p/3105636#M109412 <P>Use Calculated DAX function CustomersA= Calculate(SUM(Measure)), Customers="A")</P> Wed, 01 Mar 2023 09:57:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUM-of-measure-with-filter/m-p/3105636#M109412 ArchanaMukherji 2023-03-01T09:57:11Z Re: SUM of measure with filter https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUM-of-measure-with-filter/m-p/3105645#M109415 <P>I have hundreds of customers, the filter shall be variable</P> Wed, 01 Mar 2023 10:00:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUM-of-measure-with-filter/m-p/3105645#M109415 DAVID_DART 2023-03-01T10:00:18Z Re: SUM of measure with filter https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUM-of-measure-with-filter/m-p/3107045#M109570 <P>hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="522499" data-lia-user-login="DAVID_DART" class="lia-mention lia-mention-user">DAVID_DART</a>&nbsp;</P><P>how is your measure defined?</P> Thu, 02 Mar 2023 03:44:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUM-of-measure-with-filter/m-p/3107045#M109570 FreemanZ 2023-03-02T03:44:36Z Re: SUM of measure with filter https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUM-of-measure-with-filter/m-p/3107050#M109571 <P>Improve your question, if you want faster solution. Start <A href="https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523/highlight/true#M607150" target="_self">here</A>&nbsp;</P> Thu, 02 Mar 2023 03:54:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUM-of-measure-with-filter/m-p/3107050#M109571 smpa01 2023-03-02T03:54:37Z Re: SUM of measure with filter https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUM-of-measure-with-filter/m-p/3107269#M109600 <P>hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="460868" data-lia-user-login="FreemanZ" class="lia-mention lia-mention-user">FreemanZ</a>&nbsp;</P><P>&nbsp;</P><P>thanks for following up</P><P>my table looks in real as follows&nbsp;</P><P><img /></P><P>&nbsp;</P><P>the measure is</P><DIV><DIV><SPAN>Moyenne de Prod annuelle par LIGNE = </SPAN></DIV><DIV><SPAN>AVERAGEX</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>KEEPFILTERS</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>'Parc Machines'</SPAN><SPAN>[LIGNE]</SPAN><SPAN>)),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>AVERAGE</SPAN><SPAN>(</SPAN><SPAN>'Parc Machines'</SPAN><SPAN>[Prod annuelle]</SPAN><SPAN>))</SPAN></DIV><DIV><SPAN>)</SPAN></DIV></DIV><P>&nbsp;</P><P>I need to have a measure which is the subtotal per customer.</P><P>&nbsp;</P><P>does that make sense?</P><P>&nbsp;</P> Thu, 02 Mar 2023 07:28:29 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUM-of-measure-with-filter/m-p/3107269#M109600 DAVID_DART 2023-03-02T07:28:29Z