topic Re: Calculate Total - Wrong Total Sum in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Total-Wrong-Total-Sum/m-p/4791426#M183405 <P>Please show the incorrect total calculation result</P> Fri, 08 Aug 2025 14:27:52 GMT FBergamaschi 2025-08-08T14:27:52Z Calculate Total - Wrong Total Sum https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Total-Wrong-Total-Sum/m-p/4791412#M183404 <P>Hello All-</P><P>&nbsp;</P><P>I need to calculate the total hours worked by employees on a particular date AND specific store.</P><P>See data below and expected total hours column calculated.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Date</TD><TD>Store</TD><TD>Employee #</TD><TD>Hours Worked</TD><TD>Total Hours</TD></TR><TR><TD>01/04/2025</TD><TD>IL207</TD><TD>208468355</TD><TD>7.72</TD><TD>42.25</TD></TR><TR><TD>01/04/2025</TD><TD>IL207</TD><TD>211453196</TD><TD>7.9</TD><TD>42.25</TD></TR><TR><TD>01/04/2025</TD><TD>IL207</TD><TD>214144669</TD><TD>7.57</TD><TD>42.25</TD></TR><TR><TD>01/04/2025</TD><TD>IL207</TD><TD>216350876</TD><TD>4.93</TD><TD>42.25</TD></TR><TR><TD>01/04/2025</TD><TD>IL207</TD><TD>216350884</TD><TD>7.68</TD><TD>42.25</TD></TR><TR><TD>01/04/2025</TD><TD>IL207</TD><TD>331725085</TD><TD>6.45</TD><TD>42.25</TD></TR><TR><TD>01/04/2025</TD><TD>IL213</TD><TD>208841502</TD><TD>7.6</TD><TD>13.32</TD></TR><TR><TD>01/04/2025</TD><TD>IL213</TD><TD>327877239</TD><TD>5.72</TD><TD>13.32</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>206538415</TD><TD>6.22</TD><TD>67.93</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>209457290</TD><TD>8.2</TD><TD>67.93</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>212804512</TD><TD>8</TD><TD>67.93</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>213031131</TD><TD>6.3</TD><TD>67.93</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>213764079</TD><TD>6.2</TD><TD>67.93</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>314378134</TD><TD>8.27</TD><TD>67.93</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>319061750</TD><TD>6.07</TD><TD>67.93</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>327825824</TD><TD>6.25</TD><TD>67.93</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>328406574</TD><TD>6.4</TD><TD>67.93</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>345707210</TD><TD>6.02</TD><TD>67.93</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I tried the below however an getting the wrong total sum</P><DIV><DIV><SPAN>Total Hours =</SPAN></DIV><DIV><SPAN>CALCULATE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>SUM</SPAN><SPAN>(Table</SPAN><SPAN>[Hours Worked]</SPAN><SPAN>),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>ALLEXCEPT</SPAN><SPAN>(Table</SPAN><SPAN>, Table</SPAN><SPAN>[Date]</SPAN><SPAN>, </SPAN><SPAN>HILAN</SPAN><SPAN>[Store]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Can someone help with a DAX formula.</SPAN></DIV><DIV><SPAN>Thanks!</SPAN></DIV></DIV> Fri, 08 Aug 2025 14:18:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Total-Wrong-Total-Sum/m-p/4791412#M183404 khisla 2025-08-08T14:18:42Z Re: Calculate Total - Wrong Total Sum https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Total-Wrong-Total-Sum/m-p/4791426#M183405 <P>Please show the incorrect total calculation result</P> Fri, 08 Aug 2025 14:27:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Total-Wrong-Total-Sum/m-p/4791426#M183405 FBergamaschi 2025-08-08T14:27:52Z Re: Calculate Total - Wrong Total Sum https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Total-Wrong-Total-Sum/m-p/4791575#M183410 <P>Hi,</P> <P>Please check the below picture and the attached pbix file.</P> <P>It is for creating a calculated column.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">CC Total Hours = VAR _date = Data[Date] VAR _store = Data[Store] VAR _t = FILTER ( Data, Data[Date] = _date &amp;&amp; Data[Store] = _store ) RETURN SUMX ( _t, Data[Hours Worked] )</LI-CODE> Fri, 08 Aug 2025 17:04:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Total-Wrong-Total-Sum/m-p/4791575#M183410 Jihwan_Kim 2025-08-08T17:04:27Z Re: Calculate Total - Wrong Total Sum https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Total-Wrong-Total-Sum/m-p/4791724#M183413 <TABLE><TBODY><TR><TD>Date</TD><TD>Store</TD><TD>Employee #</TD><TD>Hour Worked</TD><TD>Total Hours</TD></TR><TR><TD>01/04/2025</TD><TD>IL207</TD><TD>208468355</TD><TD>7.72</TD><TD>81.99</TD></TR><TR><TD>01/04/2025</TD><TD>IL207</TD><TD>211453196</TD><TD>7.9</TD><TD>81.99</TD></TR><TR><TD>01/04/2025</TD><TD>IL207</TD><TD>214144669</TD><TD>7.57</TD><TD>81.99</TD></TR><TR><TD>01/04/2025</TD><TD>IL207</TD><TD>216350876</TD><TD>4.93</TD><TD>81.99</TD></TR><TR><TD>01/04/2025</TD><TD>IL207</TD><TD>216350884</TD><TD>7.68</TD><TD>81.99</TD></TR><TR><TD>01/04/2025</TD><TD>IL207</TD><TD>331725085</TD><TD>6.45</TD><TD>81.99</TD></TR><TR><TD>01/04/2025</TD><TD>IL213</TD><TD>208841502</TD><TD>7.6</TD><TD>13.32</TD></TR><TR><TD>01/04/2025</TD><TD>IL213</TD><TD>327877239</TD><TD>5.72</TD><TD>13.32</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>206538415</TD><TD>6.22</TD><TD>76.01</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>209457290</TD><TD>8.2</TD><TD>76.01</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>212804512</TD><TD>8</TD><TD>76.01</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>213031131</TD><TD>6.3</TD><TD>76.01</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>213764079</TD><TD>6.2</TD><TD>76.01</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>314378134</TD><TD>8.27</TD><TD>76.01</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>319061750</TD><TD>6.07</TD><TD>76.01</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>327825824</TD><TD>6.25</TD><TD>76.01</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>328406574</TD><TD>6.4</TD><TD>76.01</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>345707210</TD><TD>6.02</TD><TD>76.01</TD></TR></TBODY></TABLE> Fri, 08 Aug 2025 20:06:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Total-Wrong-Total-Sum/m-p/4791724#M183413 khisla 2025-08-08T20:06:51Z Re: Calculate Total - Wrong Total Sum https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Total-Wrong-Total-Sum/m-p/4791731#M183414 <P>Got the same result as my DAX which is incorrect.&nbsp; The expected total hours vary</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Date</TD><TD>Store</TD><TD>Employee #</TD><TD>Hour Worked</TD><TD>Total Hours</TD></TR><TR><TD>01/04/2025</TD><TD>IL207</TD><TD>208468355</TD><TD>7.72</TD><TD>81.99</TD></TR><TR><TD>01/04/2025</TD><TD>IL207</TD><TD>211453196</TD><TD>7.9</TD><TD>81.99</TD></TR><TR><TD>01/04/2025</TD><TD>IL207</TD><TD>214144669</TD><TD>7.57</TD><TD>81.99</TD></TR><TR><TD>01/04/2025</TD><TD>IL207</TD><TD>216350876</TD><TD>4.93</TD><TD>81.99</TD></TR><TR><TD>01/04/2025</TD><TD>IL207</TD><TD>216350884</TD><TD>7.68</TD><TD>81.99</TD></TR><TR><TD>01/04/2025</TD><TD>IL207</TD><TD>331725085</TD><TD>6.45</TD><TD>81.99</TD></TR><TR><TD>01/04/2025</TD><TD>IL213</TD><TD>208841502</TD><TD>7.6</TD><TD>13.32</TD></TR><TR><TD>01/04/2025</TD><TD>IL213</TD><TD>327877239</TD><TD>5.72</TD><TD>13.32</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>206538415</TD><TD>6.22</TD><TD>76.01</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>209457290</TD><TD>8.2</TD><TD>76.01</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>212804512</TD><TD>8</TD><TD>76.01</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>213031131</TD><TD>6.3</TD><TD>76.01</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>213764079</TD><TD>6.2</TD><TD>76.01</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>314378134</TD><TD>8.27</TD><TD>76.01</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>319061750</TD><TD>6.07</TD><TD>76.01</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>327825824</TD><TD>6.25</TD><TD>76.01</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>328406574</TD><TD>6.4</TD><TD>76.01</TD></TR><TR><TD>02/04/2025</TD><TD>IL214</TD><TD>345707210</TD><TD>6.02</TD><TD>76.01</TD></TR></TBODY></TABLE> Fri, 08 Aug 2025 20:22:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculate-Total-Wrong-Total-Sum/m-p/4791731#M183414 khisla 2025-08-08T20:22:13Z