topic Re: Cumulative sum based on another measure in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-based-on-another-measure/m-p/4662725#M178555 <P><SPAN>Hi Chaithra, I haven't had the bandwidth to review&nbsp;lbendlin's suggestion, will update this thread ASAP</SPAN></P> Tue, 22 Apr 2025 09:37:22 GMT andrew_tran 2025-04-22T09:37:22Z Cumulative sum based on another measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-based-on-another-measure/m-p/4617053#M176688 <P>Hi all,</P><P>&nbsp;</P><P>I am trying to calculate the cumulative sum based on another measure, and this cumulative sum must be responsive to all the applicable filters. I have consulted and tried the methods suggested in the following threads but all were not successful.</P><P>&nbsp;</P><P><A href="https://community.fabric.microsoft.com/t5/Desktop/Cumulative-sum-Based-on-Measure/td-p/2593795" target="_blank" rel="noopener">Solved: Cumulative sum Based on Measure - Microsoft Fabric Community</A></P><P><A href="https://community.fabric.microsoft.com/t5/Desktop/Cumulative-of-a-measure-based-on-Ranking/td-p/1326679" target="_blank" rel="noopener">Solved: Cumulative of a measure based on Ranking - Microsoft Fabric Community</A></P><P><A href="https://community.fabric.microsoft.com/t5/Desktop/A-Measure-to-Calculate-the-Cumulative-Sum-of-Another-Measure/td-p/2331768" target="_blank" rel="noopener">Solved: A Measure to Calculate the Cumulative Sum of Anoth... - Microsoft Fabric Community</A></P><P>&nbsp;</P><P><STRONG>Data Model</STRONG></P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Category</TD><TD>Product</TD><TD>Country</TD><TD>Date</TD><TD>Value</TD></TR><TR><TD>A</TD><TD>1</TD><TD>USA</TD><TD>20/3/2025</TD><TD>5695</TD></TR><TR><TD>A</TD><TD>2</TD><TD>USA</TD><TD>20/3/2025</TD><TD>9512</TD></TR><TR><TD>A</TD><TD>3</TD><TD>USA</TD><TD>20/3/2025</TD><TD>5327</TD></TR><TR><TD>A</TD><TD>4</TD><TD>USA</TD><TD>20/3/2025</TD><TD>1894</TD></TR><TR><TD>B</TD><TD>5</TD><TD>USA</TD><TD>20/3/2025</TD><TD>8015</TD></TR><TR><TD>B</TD><TD>6</TD><TD>USA</TD><TD>20/3/2025</TD><TD>8947</TD></TR><TR><TD>B</TD><TD>7</TD><TD>USA</TD><TD>20/3/2025</TD><TD>4884</TD></TR><TR><TD>B</TD><TD>8</TD><TD>USA</TD><TD>20/3/2025</TD><TD>3406</TD></TR><TR><TD>C</TD><TD>9</TD><TD>USA</TD><TD>20/3/2025</TD><TD>4986</TD></TR><TR><TD>C</TD><TD>10</TD><TD>USA</TD><TD>20/3/2025</TD><TD>8608</TD></TR><TR><TD>C</TD><TD>11</TD><TD>USA</TD><TD>20/3/2025</TD><TD>9774</TD></TR><TR><TD>C</TD><TD>12</TD><TD>USA</TD><TD>20/3/2025</TD><TD>9005</TD></TR><TR><TD>D</TD><TD>13</TD><TD>USA</TD><TD>20/3/2025</TD><TD>6792</TD></TR><TR><TD>D</TD><TD>14</TD><TD>USA</TD><TD>20/3/2025</TD><TD>2992</TD></TR><TR><TD>D</TD><TD>15</TD><TD>USA</TD><TD>20/3/2025</TD><TD>1407</TD></TR><TR><TD>D</TD><TD>16</TD><TD>USA</TD><TD>20/3/2025</TD><TD>5108</TD></TR><TR><TD>A</TD><TD>1</TD><TD>UK</TD><TD>19/3/2025</TD><TD>9448</TD></TR><TR><TD>A</TD><TD>2</TD><TD>UK</TD><TD>19/3/2025</TD><TD>1192</TD></TR><TR><TD>A</TD><TD>3</TD><TD>UK</TD><TD>19/3/2025</TD><TD>6055</TD></TR><TR><TD>A</TD><TD>4</TD><TD>UK</TD><TD>19/3/2025</TD><TD>3093</TD></TR><TR><TD>B</TD><TD>5</TD><TD>UK</TD><TD>19/3/2025</TD><TD>4799</TD></TR><TR><TD>B</TD><TD>6</TD><TD>UK</TD><TD>19/3/2025</TD><TD>8402</TD></TR><TR><TD>B</TD><TD>7</TD><TD>UK</TD><TD>19/3/2025</TD><TD>6724</TD></TR><TR><TD>B</TD><TD>8</TD><TD>UK</TD><TD>19/3/2025</TD><TD>3346</TD></TR><TR><TD>C</TD><TD>9</TD><TD>UK</TD><TD>19/3/2025</TD><TD>8850</TD></TR><TR><TD>C</TD><TD>10</TD><TD>UK</TD><TD>19/3/2025</TD><TD>5656</TD></TR><TR><TD>C</TD><TD>11</TD><TD>UK</TD><TD>19/3/2025</TD><TD>8535</TD></TR><TR><TD>C</TD><TD>12</TD><TD>UK</TD><TD>19/3/2025</TD><TD>3370</TD></TR><TR><TD>D</TD><TD>13</TD><TD>UK</TD><TD>19/3/2025</TD><TD>4926</TD></TR><TR><TD>D</TD><TD>14</TD><TD>UK</TD><TD>19/3/2025</TD><TD>9484</TD></TR><TR><TD>D</TD><TD>15</TD><TD>UK</TD><TD>19/3/2025</TD><TD>2792</TD></TR><TR><TD>D</TD><TD>16</TD><TD>UK</TD><TD>19/3/2025</TD><TD>1849</TD></TR><TR><TD>A</TD><TD>1</TD><TD>USA</TD><TD>19/3/2025</TD><TD>2817</TD></TR><TR><TD>A</TD><TD>2</TD><TD>USA</TD><TD>19/3/2025</TD><TD>8992</TD></TR><TR><TD>A</TD><TD>3</TD><TD>USA</TD><TD>19/3/2025</TD><TD>6510</TD></TR><TR><TD>A</TD><TD>4</TD><TD>USA</TD><TD>19/3/2025</TD><TD>9940</TD></TR><TR><TD>B</TD><TD>5</TD><TD>USA</TD><TD>19/3/2025</TD><TD>1058</TD></TR><TR><TD>B</TD><TD>6</TD><TD>USA</TD><TD>19/3/2025</TD><TD>3414</TD></TR><TR><TD>B</TD><TD>7</TD><TD>USA</TD><TD>19/3/2025</TD><TD>1509</TD></TR><TR><TD>B</TD><TD>8</TD><TD>USA</TD><TD>19/3/2025</TD><TD>1022</TD></TR><TR><TD>C</TD><TD>9</TD><TD>USA</TD><TD>19/3/2025</TD><TD>7779</TD></TR><TR><TD>C</TD><TD>10</TD><TD>USA</TD><TD>19/3/2025</TD><TD>1505</TD></TR><TR><TD>C</TD><TD>11</TD><TD>USA</TD><TD>19/3/2025</TD><TD>5895</TD></TR><TR><TD>C</TD><TD>12</TD><TD>USA</TD><TD>19/3/2025</TD><TD>6569</TD></TR><TR><TD>D</TD><TD>13</TD><TD>USA</TD><TD>19/3/2025</TD><TD>4569</TD></TR><TR><TD>D</TD><TD>14</TD><TD>USA</TD><TD>19/3/2025</TD><TD>1429</TD></TR><TR><TD>D</TD><TD>15</TD><TD>USA</TD><TD>19/3/2025</TD><TD>5218</TD></TR><TR><TD>D</TD><TD>16</TD><TD>USA</TD><TD>19/3/2025</TD><TD>1434</TD></TR><TR><TD>A</TD><TD>1</TD><TD>UK</TD><TD>19/3/2025</TD><TD>1201</TD></TR><TR><TD>A</TD><TD>2</TD><TD>UK</TD><TD>19/3/2025</TD><TD>5574</TD></TR><TR><TD>A</TD><TD>3</TD><TD>UK</TD><TD>19/3/2025</TD><TD>4106</TD></TR><TR><TD>A</TD><TD>4</TD><TD>UK</TD><TD>19/3/2025</TD><TD>4376</TD></TR><TR><TD>B</TD><TD>5</TD><TD>UK</TD><TD>19/3/2025</TD><TD>3175</TD></TR><TR><TD>B</TD><TD>6</TD><TD>UK</TD><TD>19/3/2025</TD><TD>6792</TD></TR><TR><TD>B</TD><TD>7</TD><TD>UK</TD><TD>19/3/2025</TD><TD>3382</TD></TR><TR><TD>B</TD><TD>8</TD><TD>UK</TD><TD>19/3/2025</TD><TD>7139</TD></TR><TR><TD>C</TD><TD>9</TD><TD>UK</TD><TD>19/3/2025</TD><TD>6033</TD></TR><TR><TD>C</TD><TD>10</TD><TD>UK</TD><TD>19/3/2025</TD><TD>2514</TD></TR><TR><TD>C</TD><TD>11</TD><TD>UK</TD><TD>19/3/2025</TD><TD>2613</TD></TR><TR><TD>C</TD><TD>12</TD><TD>UK</TD><TD>19/3/2025</TD><TD>6610</TD></TR><TR><TD>D</TD><TD>13</TD><TD>UK</TD><TD>19/3/2025</TD><TD>3502</TD></TR><TR><TD>D</TD><TD>14</TD><TD>UK</TD><TD>19/3/2025</TD><TD>3792</TD></TR><TR><TD>D</TD><TD>15</TD><TD>UK</TD><TD>19/3/2025</TD><TD>8942</TD></TR><TR><TD>D</TD><TD>16</TD><TD>UK</TD><TD>19/3/2025</TD><TD>3233</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Formulas for Sales :=&nbsp;<SPAN>Sales =</SPAN> <SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>FctTransaction</SPAN><SPAN>[Value]</SPAN><SPAN>)</SPAN></P><P>Formulas for Sales Contribution % :=&nbsp;<SPAN>Sales Contribution % =</SPAN> <SPAN>DIVIDE</SPAN><SPAN>(</SPAN><SPAN>[Sales]</SPAN><SPAN>,</SPAN><SPAN>[Sales Total]</SPAN><SPAN>)</SPAN></P><P><SPAN>Formula for Rank :=&nbsp;&nbsp;</SPAN><SPAN>Sales Contribution % Rank =</SPAN> <SPAN>IF</SPAN><SPAN>(</SPAN><SPAN>ISINSCOPE</SPAN><SPAN>(</SPAN><SPAN>FctTransaction</SPAN><SPAN>[Category]</SPAN><SPAN>),</SPAN><SPAN>RANKX</SPAN><SPAN>(</SPAN><SPAN>ALLSELECTED</SPAN><SPAN>(</SPAN><SPAN>FctTransaction</SPAN><SPAN>[Category]</SPAN><SPAN>),</SPAN><SPAN>[Sales Contribution %]</SPAN><SPAN>,,</SPAN><SPAN>DESC</SPAN><SPAN>))</SPAN></P><P>&nbsp;</P><P><STRONG>Expected Result</STRONG></P><P><img /></P><P>&nbsp;</P><P><STRONG>Actual Results</STRONG></P><P>Formular for cumu. 1 :=&nbsp;</P><DIV><DIV><SPAN>Sales Contribution % Cumulative </SPAN><SPAN>1</SPAN><SPAN> = </SPAN></DIV><DIV><SPAN>SUMX</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>FILTER</SPAN><SPAN>(</SPAN><SPAN>ALLSELECTED</SPAN><SPAN>(FctTransaction)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; ,[Sales Contribution % Rank]&lt;=</SPAN><SPAN>MAXX</SPAN><SPAN>(</SPAN><SPAN>ALLSELECTED</SPAN><SPAN>(FctTransaction),[Sales Contribution % Rank])</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; ,[Sales Contribution %]</SPAN></DIV><DIV><SPAN>)</SPAN></DIV></DIV><P><img /></P><P>&nbsp;</P><P>Formular for cumu. 2 :=&nbsp;</P><DIV><DIV><SPAN>Sales Contribution % Cumulative </SPAN><SPAN>1</SPAN><SPAN><SPAN> =&nbsp;</SPAN></SPAN><DIV><DIV><SPAN>Sales Contribution % Cumulative </SPAN><SPAN>2</SPAN><SPAN> =</SPAN></DIV><DIV><SPAN>V</SPAN><SPAN>AR</SPAN> <SPAN>C</SPAN><SPAN>urrentRank </SPAN><SPAN>= [</SPAN><SPAN>Sales Contribution % Rank]</SPAN></DIV><DIV><SPAN>RE</SPAN><SPAN>TURN</SPAN></DIV><DIV><SPAN>SUM</SPAN><SPAN>X</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>TOPN</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; [Sale</SPAN><SPAN>s Contribution % Rank]</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; ,</SPAN><SPAN>CALCUL</SPAN><SPAN>ATETABLE</SPAN><SPAN>(</SPAN><SPAN>VALUE</SPAN><SPAN>S</SPAN><SPAN>(FctTr</SPAN><SPAN>a</SPAN><SPAN>nsaction[Categ</SPAN><SPAN>ory]),</SPAN><SPAN>ALLS</SPAN><SPAN>EL</SPAN><SPAN>ECTED</SPAN><SPAN>(FctTr</SPAN><SPAN>a</SPAN><SPAN>nsaction[Categ</SPAN><SPAN>ory]))</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; ,[Sales </SPAN><SPAN>Contribution % Rank]</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; ,</SPAN><SPAN>ASC</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; ,[Sales Con</SPAN><SPAN>tribution %]</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><img /><P>&nbsp;</P></DIV><DIV><SPAN>Could any expert help to advise? Thank you so much!!</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>I have also tried to attach the underlying pbix file but was not able to do so, so my apologies.</SPAN></DIV></DIV></DIV></DIV> Wed, 19 Mar 2025 18:04:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-based-on-another-measure/m-p/4617053#M176688 andrew_tran 2025-03-19T18:04:22Z Re: Cumulative sum based on another measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-based-on-another-measure/m-p/4617309#M176702 <P>Don't make this too hard.&nbsp;</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> Wed, 19 Mar 2025 23:36:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-based-on-another-measure/m-p/4617309#M176702 lbendlin 2025-03-19T23:36:08Z Re: Cumulative sum based on another measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-based-on-another-measure/m-p/4653312#M178138 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="924907" data-lia-user-login="andrew_tran" class="lia-mention lia-mention-user">andrew_tran</a>&nbsp;,<BR /><BR />we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?<BR />If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.</P> <P>&nbsp;</P> <P>Regards,</P> <P><LI-WRAPPER></LI-WRAPPER>Chaithra</P> Tue, 15 Apr 2025 09:06:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-based-on-another-measure/m-p/4653312#M178138 v-echaithra 2025-04-15T09:06:09Z Re: Cumulative sum based on another measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-based-on-another-measure/m-p/4653321#M178139 <P>Thank you so much for this! Sorry for the late response, I haven't had the bandwidth to study your suggestion, will get back to you asap</P> Tue, 15 Apr 2025 09:09:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-based-on-another-measure/m-p/4653321#M178139 andrew_tran 2025-04-15T09:09:37Z Re: Cumulative sum based on another measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-based-on-another-measure/m-p/4653323#M178140 <P>Hi Chaithra, I haven't had the bandwidth to review&nbsp;lbendlin's suggestion, will update this thread ASAP</P> Tue, 15 Apr 2025 09:10:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-based-on-another-measure/m-p/4653323#M178140 andrew_tran 2025-04-15T09:10:46Z Re: Cumulative sum based on another measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-based-on-another-measure/m-p/4660708#M178477 <P>Hi&nbsp;<A href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/924907" target="_blank">@andrew_tran</A>&nbsp;,<BR /><BR />We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?<BR />If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.</P> <P>&nbsp;</P> <P>Regards,</P> <P><LI-WRAPPER></LI-WRAPPER>Chaithra.</P> Mon, 21 Apr 2025 09:23:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-based-on-another-measure/m-p/4660708#M178477 v-echaithra 2025-04-21T09:23:53Z Re: Cumulative sum based on another measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-based-on-another-measure/m-p/4662544#M178546 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="924907" data-lia-user-login="andrew_tran" class="lia-mention lia-mention-user">andrew_tran</a>&nbsp;,<BR /><BR /></P> <P>We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?<BR />If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.</P> <P>&nbsp;</P> <P>Regards,</P> <P><LI-WRAPPER></LI-WRAPPER>Chaithra.</P> Tue, 22 Apr 2025 07:48:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-based-on-another-measure/m-p/4662544#M178546 v-echaithra 2025-04-22T07:48:43Z Re: Cumulative sum based on another measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-based-on-another-measure/m-p/4662725#M178555 <P><SPAN>Hi Chaithra, I haven't had the bandwidth to review&nbsp;lbendlin's suggestion, will update this thread ASAP</SPAN></P> Tue, 22 Apr 2025 09:37:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-based-on-another-measure/m-p/4662725#M178555 andrew_tran 2025-04-22T09:37:22Z Re: Cumulative sum based on another measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-based-on-another-measure/m-p/4673959#M179006 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="924907" data-lia-user-login="andrew_tran" class="lia-mention lia-mention-user">andrew_tran</a>&nbsp;,<BR /><BR />As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?<BR />If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.</P> <P>&nbsp;</P> <P>Regards,</P> <P><LI-WRAPPER></LI-WRAPPER>Chaithra E.</P> Wed, 30 Apr 2025 06:25:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Cumulative-sum-based-on-another-measure/m-p/4673959#M179006 v-echaithra 2025-04-30T06:25:09Z