topic Re: Problem to calculate cumulative value for products in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problem-to-calculate-cumulative-value-for-products/m-p/3109817#M109789 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="520150" data-lia-user-login="andhiii079845" class="lia-mention lia-mention-user">andhiii079845</a>&nbsp;here an screeshot when I select all the products and one when I just select one. Like you can see the acumulative values for all the products, do not match the results on the upper graph. Do you have an Idea what is happening when trying to add up all the products into a graph? Thank you!</P><P><img /></P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Fri, 03 Mar 2023 08:29:05 GMT Luzadriana255 2023-03-03T08:29:05Z Problem to calculate cumulative value for products https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problem-to-calculate-cumulative-value-for-products/m-p/3106433#M109513 <P>Hello,<BR />I am trying to determine the cumulative quantity of products that I receive over time. For example, for the year 2022. However, the correct values are not displayed. In the table, I show the values that I receive that are not correct. I am using the following formula:</P><P>&nbsp;</P><P>Acummulative Amount =</P><P>CALCULATE(</P><P>&nbsp; &nbsp; SUM('Table'[Amount Product ]),</P><P>&nbsp; &nbsp; FILTER(</P><P>&nbsp; &nbsp; &nbsp; &nbsp; ALLSELECTED('Table'),</P><P>&nbsp; &nbsp; &nbsp; &nbsp; 'Table'[Date] &lt;= MAX('Table'[Date])</P><P>&nbsp; &nbsp; )</P><P>)</P><P>&nbsp;</P><P>&nbsp;</P><P>Could you please tell me what I should change in the formula?</P><P>&nbsp;</P><P>Thank you very much for your advice.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P>Product</P></TD><TD><P>Year</P></TD><TD><P>Month</P></TD><TD><P>Amount</P></TD><TD><P>Acummulative Amount</P></TD></TR><TR><TD><P>SRE</P></TD><TD><P>2022</P></TD><TD><P>Januar</P></TD><TD><P>78</P></TD><TD><P>211</P></TD></TR><TR><TD><P>SRE</P></TD><TD><P>2022</P></TD><TD><P>Februar</P></TD><TD><P>84</P></TD><TD><P>423</P></TD></TR><TR><TD><P>SRE</P></TD><TD><P>2022</P></TD><TD><P>März</P></TD><TD><P>61</P></TD><TD><P>651</P></TD></TR><TR><TD><P>SRE</P></TD><TD><P>2022</P></TD><TD><P>April</P></TD><TD><P>46</P></TD><TD><P>797</P></TD></TR><TR><TD><P>SRE</P></TD><TD><P>2022</P></TD><TD><P>Mai</P></TD><TD><P>45</P></TD><TD><P>979</P></TD></TR><TR><TD><P>SRE</P></TD><TD><P>2022</P></TD><TD><P>Juni</P></TD><TD><P>34</P></TD><TD><P>1115</P></TD></TR><TR><TD><P>SRE</P></TD><TD><P>2022</P></TD><TD><P>Juli</P></TD><TD><P>29</P></TD><TD><P>1288</P></TD></TR><TR><TD><P>SRE</P></TD><TD><P>2022</P></TD><TD><P>August</P></TD><TD><P>26</P></TD><TD><P>1453</P></TD></TR><TR><TD><P>SRE</P></TD><TD><P>2022</P></TD><TD><P>September</P></TD><TD><P>14</P></TD><TD><P>1639</P></TD></TR><TR><TD><P>SRE</P></TD><TD><P>2022</P></TD><TD><P>Oktober</P></TD><TD><P>26</P></TD><TD><P>1809</P></TD></TR><TR><TD><P>SRE</P></TD><TD><P>2022</P></TD><TD><P>November</P></TD><TD><P>33</P></TD><TD><P>1940</P></TD></TR><TR><TD><P>SRE</P></TD><TD><P>2022</P></TD><TD><P>Dezember</P></TD><TD><P>0</P></TD><TD>&nbsp;</TD></TR><TR><TD><P>HGT</P></TD><TD><P>2022</P></TD><TD><P>Januar</P></TD><TD><P>4</P></TD><TD><P>180</P></TD></TR><TR><TD><P>HGT</P></TD><TD><P>2022</P></TD><TD><P>Februar</P></TD><TD><P>12</P></TD><TD><P>379</P></TD></TR><TR><TD><P>HGT</P></TD><TD><P>2022</P></TD><TD><P>März</P></TD><TD><P>19</P></TD><TD><P>651</P></TD></TR><TR><TD><P>HGT</P></TD><TD><P>2022</P></TD><TD><P>April</P></TD><TD><P>11</P></TD><TD><P>782</P></TD></TR><TR><TD><P>HGT</P></TD><TD><P>2022</P></TD><TD><P>Mai</P></TD><TD><P>25</P></TD><TD><P>979</P></TD></TR><TR><TD><P>HGT</P></TD><TD><P>2022</P></TD><TD><P>Juni</P></TD><TD><P>16</P></TD><TD><P>1115</P></TD></TR><TR><TD><P>HGT</P></TD><TD><P>2022</P></TD><TD><P>Juli</P></TD><TD><P>15</P></TD><TD><P>1288</P></TD></TR><TR><TD><P>HGT</P></TD><TD><P>2022</P></TD><TD><P>August</P></TD><TD><P>21</P></TD><TD><P>1457</P></TD></TR><TR><TD><P>HGT</P></TD><TD><P>2022</P></TD><TD><P>September</P></TD><TD><P>22</P></TD><TD><P>1656</P></TD></TR><TR><TD><P>HGT</P></TD><TD><P>2022</P></TD><TD><P>Oktober</P></TD><TD><P>15</P></TD><TD><P>1806</P></TD></TR><TR><TD><P>HGT</P></TD><TD><P>2022</P></TD><TD><P>November</P></TD><TD><P>20</P></TD><TD><P>1940</P></TD></TR><TR><TD><P>HGT</P></TD><TD><P>2022</P></TD><TD><P>Dezember</P></TD><TD><P>0</P></TD><TD>&nbsp;</TD></TR><TR><TD><P>TRA</P></TD><TD><P>2022</P></TD><TD><P>Januar</P></TD><TD><P>69</P></TD><TD><P>204</P></TD></TR><TR><TD><P>TRA</P></TD><TD><P>2022</P></TD><TD><P>Februar</P></TD><TD><P>71</P></TD><TD><P>423</P></TD></TR><TR><TD><P>TRA</P></TD><TD><P>2022</P></TD><TD><P>März</P></TD><TD><P>62</P></TD><TD><P>651</P></TD></TR><TR><TD><P>TRA</P></TD><TD><P>2022</P></TD><TD><P>April</P></TD><TD><P>24</P></TD><TD><P>797</P></TD></TR><TR><TD><P>TRA</P></TD><TD><P>2022</P></TD><TD><P>Mai</P></TD><TD><P>44</P></TD><TD><P>979</P></TD></TR><TR><TD><P>TRA</P></TD><TD><P>2022</P></TD><TD><P>Juni</P></TD><TD><P>40</P></TD><TD><P>1115</P></TD></TR><TR><TD><P>TRA</P></TD><TD><P>2022</P></TD><TD><P>Juli</P></TD><TD><P>56</P></TD><TD><P>1288</P></TD></TR><TR><TD><P>TRA</P></TD><TD><P>2022</P></TD><TD><P>August</P></TD><TD><P>48</P></TD><TD><P>1453</P></TD></TR><TR><TD><P>TRA</P></TD><TD><P>2022</P></TD><TD><P>September</P></TD><TD><P>106</P></TD><TD><P>1661</P></TD></TR><TR><TD><P>TRA</P></TD><TD><P>2022</P></TD><TD><P>Oktober</P></TD><TD><P>51</P></TD><TD><P>1806</P></TD></TR><TR><TD><P>TRA</P></TD><TD><P>2022</P></TD><TD><P>November</P></TD><TD><P>21</P></TD><TD><P>1947</P></TD></TR><TR><TD><P>TRA</P></TD><TD><P>2022</P></TD><TD><P>Dezember</P></TD><TD><P>0</P></TD><TD>&nbsp;</TD></TR><TR><TD><P>ZWI</P></TD><TD><P>2022</P></TD><TD><P>Januar</P></TD><TD><P>2</P></TD><TD><P>118</P></TD></TR><TR><TD><P>ZWI</P></TD><TD><P>2022</P></TD><TD><P>Februar</P></TD><TD><P>2</P></TD><TD><P>360</P></TD></TR><TR><TD><P>ZWI</P></TD><TD><P>2022</P></TD><TD><P>März</P></TD><TD><P>3</P></TD><TD><P>540</P></TD></TR><TR><TD><P>ZWI</P></TD><TD><P>2022</P></TD><TD><P>April</P></TD><TD><P>5</P></TD><TD><P>774</P></TD></TR><TR><TD><P>ZWI</P></TD><TD><P>2022</P></TD><TD><P>Mai</P></TD><TD><P>4</P></TD><TD><P>843</P></TD></TR><TR><TD><P>ZWI</P></TD><TD><P>2022</P></TD><TD><P>Juni</P></TD><TD><P>3</P></TD><TD><P>1115</P></TD></TR><TR><TD><P>ZWI</P></TD><TD><P>2022</P></TD><TD><P>Juli</P></TD><TD><P>1</P></TD><TD><P>1129</P></TD></TR><TR><TD><P>ZWI</P></TD><TD><P>2022</P></TD><TD><P>August</P></TD><TD><P>5</P></TD><TD><P>1432</P></TD></TR><TR><TD><P>ZWI</P></TD><TD><P>2022</P></TD><TD><P>September</P></TD><TD><P>1</P></TD><TD><P>1536</P></TD></TR><TR><TD><P>ZWI</P></TD><TD><P>2022</P></TD><TD><P>Oktober</P></TD><TD><P>7</P></TD><TD><P>1793</P></TD></TR><TR><TD><P>ZWI</P></TD><TD><P>2022</P></TD><TD><P>November</P></TD><TD><P>10</P></TD><TD><P>1947</P></TD></TR><TR><TD><P>ZWI</P></TD><TD><P>2022</P></TD><TD><P>Dezember</P></TD><TD><P>0</P></TD><TD>&nbsp;</TD></TR><TR><TD><P>DSU</P></TD><TD><P>2022</P></TD><TD><P>Januar</P></TD><TD><P>51</P></TD><TD><P>211</P></TD></TR><TR><TD><P>DSU</P></TD><TD><P>2022</P></TD><TD><P>Februar</P></TD><TD><P>38</P></TD><TD><P>424</P></TD></TR><TR><TD><P>DSU</P></TD><TD><P>2022</P></TD><TD><P>März</P></TD><TD><P>75</P></TD><TD><P>651</P></TD></TR><TR><TD><P>DSU</P></TD><TD><P>2022</P></TD><TD><P>April</P></TD><TD><P>57</P></TD><TD><P>797</P></TD></TR><TR><TD><P>DSU</P></TD><TD><P>2022</P></TD><TD><P>Mai</P></TD><TD><P>62</P></TD><TD><P>979</P></TD></TR><TR><TD><P>DSU</P></TD><TD><P>2022</P></TD><TD><P>Juni</P></TD><TD><P>41</P></TD><TD><P>1115</P></TD></TR><TR><TD><P>DSU</P></TD><TD><P>2022</P></TD><TD><P>Juli</P></TD><TD><P>72</P></TD><TD><P>1288</P></TD></TR><TR><TD><P>DSU</P></TD><TD><P>2022</P></TD><TD><P>August</P></TD><TD><P>69</P></TD><TD><P>1457</P></TD></TR><TR><TD><P>DSU</P></TD><TD><P>2022</P></TD><TD><P>September</P></TD><TD><P>60</P></TD><TD><P>1661</P></TD></TR><TR><TD><P>DSU</P></TD><TD><P>2022</P></TD><TD><P>Oktober</P></TD><TD><P>49</P></TD><TD><P>1809</P></TD></TR><TR><TD><P>DSU</P></TD><TD><P>2022</P></TD><TD><P>November</P></TD><TD><P>51</P></TD><TD><P>1947</P></TD></TR><TR><TD><P>DSU</P></TD><TD><P>2022</P></TD><TD><P>Dezember</P></TD><TD><P>0</P></TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P> Wed, 01 Mar 2023 18:25:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problem-to-calculate-cumulative-value-for-products/m-p/3106433#M109513 Luzadriana255 2023-03-01T18:25:49Z Re: Problem to calculate cumulative value for products https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problem-to-calculate-cumulative-value-for-products/m-p/3106442#M109514 <P>Try this:<BR /><A href="https://community.powerbi.com/t5/DAX-Commands-and-Tips/cumulative-sum-by-date-and-product/td-p/1973888" target="_blank">https://community.powerbi.com/t5/DAX-Commands-and-Tips/cumulative-sum-by-date-and-product/td-p/1973888</A></P><P>&nbsp;</P><P>Like this:&nbsp;</P><LI-CODE lang="markup">Cumulative Value = VAR varDate = SELECTEDVALUE('Table'[Date]) RETURN CALCULATE( 'Table'[Amount Product ], 'Table'[Date] &lt;= varDate )</LI-CODE><P>&nbsp;</P> Wed, 01 Mar 2023 18:30:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problem-to-calculate-cumulative-value-for-products/m-p/3106442#M109514 andhiii079845 2023-03-01T18:30:45Z Re: Problem to calculate cumulative value for products https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problem-to-calculate-cumulative-value-for-products/m-p/3107480#M109626 <P>Thank you, it works on the individual level of products. But unfortunatly I still have Problems when trying to graph all products together. The values are completely different.&nbsp;</P> Thu, 02 Mar 2023 09:40:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problem-to-calculate-cumulative-value-for-products/m-p/3107480#M109626 Luzadriana255 2023-03-02T09:40:36Z Re: Problem to calculate cumulative value for products https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problem-to-calculate-cumulative-value-for-products/m-p/3107568#M109634 <P>Can you please show a example?</P> Thu, 02 Mar 2023 10:28:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problem-to-calculate-cumulative-value-for-products/m-p/3107568#M109634 andhiii079845 2023-03-02T10:28:21Z Re: Problem to calculate cumulative value for products https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problem-to-calculate-cumulative-value-for-products/m-p/3109817#M109789 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="520150" data-lia-user-login="andhiii079845" class="lia-mention lia-mention-user">andhiii079845</a>&nbsp;here an screeshot when I select all the products and one when I just select one. Like you can see the acumulative values for all the products, do not match the results on the upper graph. Do you have an Idea what is happening when trying to add up all the products into a graph? Thank you!</P><P><img /></P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Fri, 03 Mar 2023 08:29:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Problem-to-calculate-cumulative-value-for-products/m-p/3109817#M109789 Luzadriana255 2023-03-03T08:29:05Z