topic Calculate using DAX in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-using-DAX/m-p/2745769#M84558 <TABLE><TBODY><TR><TD>CW</TD><TD>StoreID</TD><TD>CatID</TD><TD>MatID</TD><TD>SaleVolume</TD></TR><TR><TD>1</TD><TD>Store1</TD><TD>2</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18,674.64</TD></TR><TR><TD>1</TD><TD>Store1</TD><TD>3</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15,118.37</TD></TR><TR><TD>1</TD><TD>Store1</TD><TD>1</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 107,588.30</TD></TR><TR><TD>1</TD><TD>Store2</TD><TD>2</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14,010.44</TD></TR><TR><TD>1</TD><TD>Store2</TD><TD>3</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9,789.39</TD></TR><TR><TD>1</TD><TD>Store2</TD><TD>1</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 28,643.33</TD></TR><TR><TD>1</TD><TD>Store3</TD><TD>2</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14,680.86</TD></TR><TR><TD>1</TD><TD>Store3</TD><TD>3</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12,438.25</TD></TR><TR><TD>1</TD><TD>Store3</TD><TD>1</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 41,714.96</TD></TR><TR><TD>1</TD><TD>Store4</TD><TD>2</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,908.21</TD></TR><TR><TD>1</TD><TD>Store4</TD><TD>3</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17,931.38</TD></TR><TR><TD>1</TD><TD>Store4</TD><TD>1</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 39,634.22</TD></TR><TR><TD>2</TD><TD>Store1</TD><TD>2</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 19,838.09</TD></TR><TR><TD>2</TD><TD>Store1</TD><TD>3</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12,786.31</TD></TR><TR><TD>2</TD><TD>Store1</TD><TD>1</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 44,042.58</TD></TR><TR><TD>2</TD><TD>Store2</TD><TD>2</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15,187.15</TD></TR><TR><TD>2</TD><TD>Store2</TD><TD>3</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11,641.98</TD></TR><TR><TD>2</TD><TD>Store2</TD><TD>1</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24,876.50</TD></TR><TR><TD>2</TD><TD>Store3</TD><TD>2</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,848.64</TD></TR><TR><TD>2</TD><TD>Store3</TD><TD>3</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9,554.36</TD></TR><TR><TD>2</TD><TD>Store3</TD><TD>1</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20,857.48</TD></TR><TR><TD>2</TD><TD>Store4</TD><TD>2</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,537.00</TD></TR><TR><TD>2</TD><TD>Store4</TD><TD>3</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6,441.51</TD></TR><TR><TD>2</TD><TD>Store4</TD><TD>1</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8,110.98</TD></TR><TR><TD>3</TD><TD>Store1</TD><TD>2</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20,855.73</TD></TR></TBODY></TABLE><P>there are 52 weeks in column CW for four stores .</P><P>Weeding season weeks are-&nbsp; 1,2,3,49,50,51 and 52.</P><P>&nbsp;</P><P>How can I calculate - A measure that calculates the total amount of sales during the Wedding Season.</P> Sun, 04 Sep 2022 05:46:48 GMT Anonymous 2022-09-04T05:46:48Z Calculate using DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-using-DAX/m-p/2745769#M84558 <TABLE><TBODY><TR><TD>CW</TD><TD>StoreID</TD><TD>CatID</TD><TD>MatID</TD><TD>SaleVolume</TD></TR><TR><TD>1</TD><TD>Store1</TD><TD>2</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18,674.64</TD></TR><TR><TD>1</TD><TD>Store1</TD><TD>3</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15,118.37</TD></TR><TR><TD>1</TD><TD>Store1</TD><TD>1</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 107,588.30</TD></TR><TR><TD>1</TD><TD>Store2</TD><TD>2</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14,010.44</TD></TR><TR><TD>1</TD><TD>Store2</TD><TD>3</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9,789.39</TD></TR><TR><TD>1</TD><TD>Store2</TD><TD>1</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 28,643.33</TD></TR><TR><TD>1</TD><TD>Store3</TD><TD>2</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14,680.86</TD></TR><TR><TD>1</TD><TD>Store3</TD><TD>3</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12,438.25</TD></TR><TR><TD>1</TD><TD>Store3</TD><TD>1</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 41,714.96</TD></TR><TR><TD>1</TD><TD>Store4</TD><TD>2</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,908.21</TD></TR><TR><TD>1</TD><TD>Store4</TD><TD>3</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17,931.38</TD></TR><TR><TD>1</TD><TD>Store4</TD><TD>1</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 39,634.22</TD></TR><TR><TD>2</TD><TD>Store1</TD><TD>2</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 19,838.09</TD></TR><TR><TD>2</TD><TD>Store1</TD><TD>3</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12,786.31</TD></TR><TR><TD>2</TD><TD>Store1</TD><TD>1</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 44,042.58</TD></TR><TR><TD>2</TD><TD>Store2</TD><TD>2</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15,187.15</TD></TR><TR><TD>2</TD><TD>Store2</TD><TD>3</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11,641.98</TD></TR><TR><TD>2</TD><TD>Store2</TD><TD>1</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24,876.50</TD></TR><TR><TD>2</TD><TD>Store3</TD><TD>2</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,848.64</TD></TR><TR><TD>2</TD><TD>Store3</TD><TD>3</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9,554.36</TD></TR><TR><TD>2</TD><TD>Store3</TD><TD>1</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20,857.48</TD></TR><TR><TD>2</TD><TD>Store4</TD><TD>2</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,537.00</TD></TR><TR><TD>2</TD><TD>Store4</TD><TD>3</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6,441.51</TD></TR><TR><TD>2</TD><TD>Store4</TD><TD>1</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8,110.98</TD></TR><TR><TD>3</TD><TD>Store1</TD><TD>2</TD><TD>1</TD><TD>&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20,855.73</TD></TR></TBODY></TABLE><P>there are 52 weeks in column CW for four stores .</P><P>Weeding season weeks are-&nbsp; 1,2,3,49,50,51 and 52.</P><P>&nbsp;</P><P>How can I calculate - A measure that calculates the total amount of sales during the Wedding Season.</P> Sun, 04 Sep 2022 05:46:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-using-DAX/m-p/2745769#M84558 Anonymous 2022-09-04T05:46:48Z Re: Calculate using DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-using-DAX/m-p/2745934#M84568 <P>HI&nbsp;Anonymous</LI-USER>&nbsp;,</P> <P>&nbsp;</P> <P>You can try this:</P> <LI-CODE lang="markup">Weeding Season Sales = CALCULATE( SUM('Table'[SaleVolume]) ,'Table'[CW] IN {1, 2, 3, 49, 50, 51, 52})</LI-CODE> Sun, 04 Sep 2022 10:15:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-using-DAX/m-p/2745934#M84568 Adescrit 2022-09-04T10:15:11Z Re: Calculate using DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-using-DAX/m-p/2754452#M85093 <P>Hi,&nbsp;Anonymous</LI-USER>&nbsp;</P> <P>&nbsp;</P> <P><SPAN>Has your problem been solved, if so, please consider Accept a correct reply as the solution.&nbsp;If not, please provide more details and the output you expect.</SPAN></P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Community Support Team _Charlotte</P> <P>If this post<SPAN>&nbsp;</SPAN><STRONG>helps</STRONG>, then please consider<SPAN>&nbsp;</SPAN><STRONG><EM>Accept it as the solution</EM></STRONG><SPAN>&nbsp;</SPAN>to help the other members find it more quickly.</P> Thu, 08 Sep 2022 06:51:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-using-DAX/m-p/2754452#M85093 v-zhangti 2022-09-08T06:51:12Z