topic Re: Measure created is not totalling correctly in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-created-is-not-totalling-correctly/m-p/3444370#M130932 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="621587" data-lia-user-login="srrajesh1" class="lia-mention lia-mention-user">srrajesh1</a>&nbsp;</P> <P>Please try</P> <P>Eligible Deliveries =<BR />SUMX (<BR />SUMMARIZE (<BR />'Dashboard-23-24',<BR />'Dashboard-23-24'[Runsheet Date],<BR />'Dashboard-23-24'[Supplier]<BR />),<BR />SUMX (<BR />FILTER (<BR />CALCULATETABLE ( 'Dashboard-23-24' ),<BR />( 'Dashboard-23-24'[Supplier] = "Zainway Fixed"<BR />|| 'Dashboard-23-24'[Supplier] = "Own" )<BR />&amp;&amp; 'Dashboard-23-24'[Delivered] + 'Dashboard-23-24'[Picked UP] &gt; 'Dashboard-23-24'[Target1]<BR />),<BR />'Dashboard-23-24'[Delivered] + 'Dashboard-23-24'[Picked UP] - 'Dashboard-23-24'[Target1]<BR />)<BR />)</P> Sat, 23 Sep 2023 20:05:26 GMT tamerj1 2023-09-23T20:05:26Z Measure created is not totalling correctly https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-created-is-not-totalling-correctly/m-p/3444357#M130929 <P class="lia-align-left">&nbsp;</P><DIV><DIV><SPAN>Eligible Deliveries =</SPAN></DIV><DIV><SPAN>SUMX</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>'Dashboard-23-24'</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; (</SPAN><SPAN>'Dashboard-23-24'</SPAN><SPAN>[Supplier]</SPAN><SPAN> = </SPAN><SPAN>"Zainway Fixed"</SPAN><SPAN> || </SPAN><SPAN>'Dashboard-23-24'</SPAN><SPAN>[Supplier]</SPAN><SPAN> = </SPAN><SPAN>"Own"</SPAN><SPAN>) &amp;&amp;</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>'Dashboard-23-24'</SPAN><SPAN>[Delivered]</SPAN><SPAN> + </SPAN><SPAN>'Dashboard-23-24'</SPAN><SPAN>[Picked UP]</SPAN><SPAN> &gt; </SPAN><SPAN>'Dashboard-23-24'</SPAN><SPAN>[Target1]</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>'Dashboard-23-24'</SPAN><SPAN>[Delivered]</SPAN><SPAN> + </SPAN><SPAN>'Dashboard-23-24'</SPAN><SPAN>[Picked UP]</SPAN><SPAN> - </SPAN><SPAN>'Dashboard-23-24'</SPAN><SPAN>[Target1]</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>above is the measure I have created. While calculating total it returns wrong result. </SPAN></DIV><DIV>Result is given below.</DIV><DIV>&nbsp;</DIV><DIV>Correct Total of ELigible deliveries should be <STRONG>361,</STRONG> where as it simply minus target and gives wrong totalling. Kindly help me to correct it.</DIV><DIV><TABLE><TBODY><TR><TD>Runsheet Date</TD><TD>Supplier</TD><TD>AWB Distinct Count</TD><TD>Delivered</TD><TD>Picked UP</TD><TD>Inside Doha</TD><TD>Out of Doha</TD><TD>Delivered+Picked Up</TD><TD>Target</TD><TD>Eligible Deliveries</TD><TD>Del Amt/Incentive</TD></TR><TR><TD>9/22/2023 0:00</TD><TD>OWN</TD><TD>84</TD><TD>67</TD><TD>13</TD><TD>80</TD><TD>&nbsp;</TD><TD>80</TD><TD>30</TD><TD>50</TD><TD>200</TD></TR><TR><TD>9/22/2023 0:00</TD><TD>OWN</TD><TD>50</TD><TD>40</TD><TD>8</TD><TD>41</TD><TD>7</TD><TD>48</TD><TD>30</TD><TD>18</TD><TD>72</TD></TR><TR><TD>9/22/2023 0:00</TD><TD>OWN</TD><TD>57</TD><TD>54</TD><TD>1</TD><TD>55</TD><TD>&nbsp;</TD><TD>55</TD><TD>30</TD><TD>25</TD><TD>100</TD></TR><TR><TD>9/22/2023 0:00</TD><TD>OWN</TD><TD>33</TD><TD>27</TD><TD>4</TD><TD>31</TD><TD>&nbsp;</TD><TD>31</TD><TD>30</TD><TD>1</TD><TD>4</TD></TR><TR><TD>9/22/2023 0:00</TD><TD>OWN</TD><TD>55</TD><TD>50</TD><TD>0</TD><TD>50</TD><TD>&nbsp;</TD><TD>50</TD><TD>30</TD><TD>20</TD><TD>80</TD></TR><TR><TD>9/22/2023 0:00</TD><TD>OWN</TD><TD>63</TD><TD>56</TD><TD>4</TD><TD>59</TD><TD>1</TD><TD>60</TD><TD>30</TD><TD>30</TD><TD>120</TD></TR><TR><TD>9/22/2023 0:00</TD><TD>OWN</TD><TD>71</TD><TD>61</TD><TD>6</TD><TD>67</TD><TD>&nbsp;</TD><TD>67</TD><TD>30</TD><TD>37</TD><TD>148</TD></TR><TR><TD>9/22/2023 0:00</TD><TD>OWN</TD><TD>66</TD><TD>55</TD><TD>9</TD><TD>&nbsp;</TD><TD>64</TD><TD>64</TD><TD>30</TD><TD>34</TD><TD>136</TD></TR><TR><TD>9/22/2023 0:00</TD><TD>OWN</TD><TD>48</TD><TD>42</TD><TD>4</TD><TD>46</TD><TD>&nbsp;</TD><TD>46</TD><TD>30</TD><TD>16</TD><TD>64</TD></TR><TR><TD>9/22/2023 0:00</TD><TD>OWN</TD><TD>56</TD><TD>46</TD><TD>8</TD><TD>54</TD><TD>&nbsp;</TD><TD>54</TD><TD>30</TD><TD>24</TD><TD>96</TD></TR><TR><TD>9/22/2023 0:00</TD><TD>OWN</TD><TD>57</TD><TD>51</TD><TD>4</TD><TD>55</TD><TD>&nbsp;</TD><TD>55</TD><TD>30</TD><TD>25</TD><TD>100</TD></TR><TR><TD>9/22/2023 0:00</TD><TD>OWN</TD><TD>30</TD><TD>28</TD><TD>0</TD><TD>28</TD><TD>&nbsp;</TD><TD>28</TD><TD>30</TD><TD>0</TD><TD>0</TD></TR><TR><TD>9/22/2023 0:00</TD><TD>OWN</TD><TD>67</TD><TD>52</TD><TD>8</TD><TD>60</TD><TD>&nbsp;</TD><TD>60</TD><TD>30</TD><TD>30</TD><TD>120</TD></TR><TR><TD>9/22/2023 0:00</TD><TD>OWN</TD><TD>27</TD><TD>22</TD><TD>1</TD><TD>23</TD><TD>&nbsp;</TD><TD>23</TD><TD>30</TD><TD>0</TD><TD>0</TD></TR><TR><TD>9/22/2023 0:00</TD><TD>OWN</TD><TD>42</TD><TD>40</TD><TD>2</TD><TD>42</TD><TD>&nbsp;</TD><TD>42</TD><TD>30</TD><TD>12</TD><TD>48</TD></TR><TR><TD>9/22/2023 0:00</TD><TD>OWN</TD><TD>70</TD><TD>66</TD><TD>3</TD><TD>69</TD><TD>&nbsp;</TD><TD>69</TD><TD>30</TD><TD>39</TD><TD>156</TD></TR><TR><TD>Total</TD><TD>&nbsp;</TD><TD>876</TD><TD>757</TD><TD>75</TD><TD>760</TD><TD>72</TD><TD>832</TD><TD>30</TD><TD>802</TD><TD>3208</TD></TR></TBODY></TABLE></DIV><DIV>&nbsp;</DIV></DIV> Sat, 23 Sep 2023 19:00:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-created-is-not-totalling-correctly/m-p/3444357#M130929 srrajesh1 2023-09-23T19:00:43Z Re: Measure created is not totalling correctly https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-created-is-not-totalling-correctly/m-p/3444370#M130932 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="621587" data-lia-user-login="srrajesh1" class="lia-mention lia-mention-user">srrajesh1</a>&nbsp;</P> <P>Please try</P> <P>Eligible Deliveries =<BR />SUMX (<BR />SUMMARIZE (<BR />'Dashboard-23-24',<BR />'Dashboard-23-24'[Runsheet Date],<BR />'Dashboard-23-24'[Supplier]<BR />),<BR />SUMX (<BR />FILTER (<BR />CALCULATETABLE ( 'Dashboard-23-24' ),<BR />( 'Dashboard-23-24'[Supplier] = "Zainway Fixed"<BR />|| 'Dashboard-23-24'[Supplier] = "Own" )<BR />&amp;&amp; 'Dashboard-23-24'[Delivered] + 'Dashboard-23-24'[Picked UP] &gt; 'Dashboard-23-24'[Target1]<BR />),<BR />'Dashboard-23-24'[Delivered] + 'Dashboard-23-24'[Picked UP] - 'Dashboard-23-24'[Target1]<BR />)<BR />)</P> Sat, 23 Sep 2023 20:05:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-created-is-not-totalling-correctly/m-p/3444370#M130932 tamerj1 2023-09-23T20:05:26Z