topic Need help calculating a cumulative sum of measures? in Desktop
https://community.powerbi.com/t5/Desktop/Need-help-calculating-a-cumulative-sum-of-measures/m-p/1249173#M551259
<P>Hi Community,<BR /><BR />I'm working on a project that calculates a total of mix impact when comparing data between 2 selected periods. I have measures that calculate all of component, but I can't sum them up as a total. Is there a way to do it?<BR /><BR />Below is a mock data.</P><P> </P><P><U><STRONG>Fact Table</STRONG></U></P><TABLE border="1"><TBODY><TR><TD>Period ID</TD><TD>State</TD><TD>Type</TD><TD>Type</TD></TR><TR><TD>1</TD><TD>CA</TD><TD>Volume</TD><TD>10000</TD></TR><TR><TD>1</TD><TD>CA</TD><TD>Cost</TD><TD>50000</TD></TR><TR><TD>1</TD><TD>NY</TD><TD>Volume</TD><TD>1500</TD></TR><TR><TD>1</TD><TD>NY</TD><TD>Cost</TD><TD>15000</TD></TR><TR><TD>2</TD><TD>CA</TD><TD>Volume</TD><TD>8000</TD></TR><TR><TD>2</TD><TD>CA</TD><TD>Cost</TD><TD>45000</TD></TR><TR><TD>2</TD><TD>NY</TD><TD>Volume</TD><TD>3000</TD></TR><TR><TD>2</TD><TD>NY</TD><TD>Cost</TD><TD>20000</TD></TR><TR><TD>2</TD><TD>TX</TD><TD>Volume</TD><TD>1000</TD></TR><TR><TD>2</TD><TD>TX</TD><TD>Cost</TD><TD>6000</TD></TR><TR><TD>3</TD><TD>NY</TD><TD>Volume</TD><TD>2500</TD></TR><TR><TD>3</TD><TD>NY</TD><TD>Cost</TD><TD>10000</TD></TR><TR><TD>3</TD><TD>TX</TD><TD>Volume</TD><TD>1000</TD></TR><TR><TD>3</TD><TD>TX</TD><TD>Cost</TD><TD>5000</TD></TR></TBODY></TABLE><P> </P><P>User will use 2 slicers to select data for a comparison. These slicers are Period ID. Let's say a user select peiord 1 in slicer #1 and period 2 in slicer #2</P><P> </P><P>The calculation logics:</P><P> </P><TABLE border="1"><TBODY><TR><TD>Period 1</TD></TR><TR><TD>State</TD><TD>Vol</TD><TD>Cost</TD><TD>Avg</TD></TR><TR><TD>CA</TD><TD>10000</TD><TD>50000</TD><TD>5</TD></TR><TR><TD>NY</TD><TD>1500</TD><TD>15000</TD><TD>10</TD></TR><TR><TD>TX</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Total</TD><TD>11500</TD><TD>65000</TD><TD>5.652174</TD></TR></TBODY></TABLE><P> </P><TABLE border="1"><TBODY><TR><TD>Period 2</TD></TR><TR><TD>State</TD><TD>Vol</TD><TD>Cost</TD><TD>Avg</TD></TR><TR><TD>CA</TD><TD>8000</TD><TD>45000</TD><TD>5.625</TD></TR><TR><TD>NY</TD><TD>3000</TD><TD>20000</TD><TD>6.666667</TD></TR><TR><TD>TX</TD><TD>1000</TD><TD>6000</TD><TD>6</TD></TR><TR><TD>Total</TD><TD>12000</TD><TD>71000</TD><TD>5.916667</TD></TR></TBODY></TABLE><P> </P><P>First we find a total of Volume, Cost, and Average for each period. Here are the measures </P><DIV><DIV><SPAN>[Volume Sel 1] >> a total volume of each state</SPAN></DIV><DIV><DIV><SPAN>[Total Volume Sel 1] >> a total volume of all state in a period<BR />[Avg Cost Sel 1] >> an average cost of each state</SPAN></DIV><DIV><SPAN>[Total Avg Cost Sel 1] >> an average cost of all state in a period</SPAN></DIV><DIV> </DIV><DIV>selection #2 has the same measures</DIV></DIV></DIV><P> </P><P>Now, we have to find a percentage of a volume from each state comparing to a total of all state in a period. Then, we find what a percentage change of each state between 2 period </P><P> </P><TABLE border="1"><TBODY><TR><TD>Vol %</TD></TR><TR><TD>State</TD><TD>Period 1</TD><TD>Period 2</TD><TD>Chg</TD></TR><TR><TD>CA</TD><TD>0.8695652</TD><TD>0.666666667</TD><TD>-0.2029</TD></TR><TR><TD>NY</TD><TD>0.1304348</TD><TD>0.25</TD><TD>0.119565</TD></TR><TR><TD>TX</TD><TD>0</TD><TD>0.083333333</TD><TD>0.083333</TD></TR><TR><TD>Total</TD><TD>1</TD><TD>1</TD><TD>0</TD></TR></TBODY></TABLE><P> </P><P>Once we have a percentage different of each state, we will each state volume impact. To do this, we use a percentage different multiply by a total volume of all state from period #1</P><P> </P><P>To find Avg cost Impact of each state, we use state cost average from period #1 subtract by a total average cost from period #1. Since TX didn't have an average cost in period #1, we use TX average cost from period #2 and subtract by a total average cost from period #1.</P><P> </P><TABLE border="1"><TBODY><TR><TD>Dol Impact</TD></TR><TR><TD>State</TD><TD>Vol Impact</TD><TD>Avg Impact</TD><TD> </TD></TR><TR><TD>CA</TD><TD>-2333.3333</TD><TD>-0.65217391</TD><TD>1521.739</TD></TR><TR><TD>NY</TD><TD>1375</TD><TD>4.347826087</TD><TD>5978.261</TD></TR><TR><TD>TX</TD><TD>958.33333</TD><TD>0.347826087</TD><TD>333.3333</TD></TR><TR><TD>Total</TD><TD> </TD><TD> </TD><TD><FONT color="#339966">7833.333</FONT></TD></TR></TBODY></TABLE><P> </P><P>Once we have both Vol Impact and Avg Impact, we will calculate Dol Impact by multiply Vol Impact by Avg Impact then sum all of state Dol Impact to get our total Dol Impact. <BR /><BR />Here is my Dol Impact measure code</P><P> </P><P>Dol Impact = </P><DIV><DIV><SPAN>VAR Vol1_Pct = [Volume Sel 1] / [Total Volume Sel 1] </SPAN></DIV><DIV><SPAN>VAR Vol2_Pct = [Volume Sel 2] / [Total Volume Sel 2]</SPAN></DIV><DIV><SPAN><SPAN>VAR Pct_Diff = Vol1_Pct - Vol2_Pct<BR /></SPAN></SPAN><DIV><SPAN><SPAN>VAR Vol_Impact = Pct_Diff * [Total Volume Sel 1]<BR /></SPAN></SPAN><DIV><DIV><SPAN>VAR AvgCost_Impact =</SPAN></DIV><DIV class="lia-indent-padding-left-30px"><SPAN>IF([Volume Sel 1] <> 0, [<SPAN>Avg Cost Sel 1</SPAN>], [<SPAN>Avg Cost Sel 2</SPAN></SPAN><SPAN>) - IF([Total Volume Sel 1] <> 0, [Total <SPAN>Avg Cost Sel 1</SPAN>], [Total <SPAN>Avg Cost Sel 2</SPAN>])</SPAN></DIV><DIV><DIV><DIV><SPAN>VAR Dollar_Impact = Vol_Impact * AvgCost_Impact</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>Dollar_Impact</SPAN></DIV><DIV> </DIV><DIV><SPAN>So, when I put this Dol Impact measure in a Matrix table with State as rows, it displays each state dollar impact correctly, but the total line shows 0. My goal is to display a total dollar impact as a card. As of right now, it shows 0 as a total dollar impact as a card. </SPAN></DIV><DIV> </DIV><DIV><SPAN>Is there a way to sum each state dollar impact up and display as one value? Please help! Thank you for your time.</SPAN></DIV></DIV></DIV></DIV></DIV></DIV></DIV>Fri, 24 Jul 2020 17:47:55 GMTMaxemus20002020-07-24T17:47:55ZNeed help calculating a cumulative sum of measures?
https://community.powerbi.com/t5/Desktop/Need-help-calculating-a-cumulative-sum-of-measures/m-p/1249173#M551259
<P>Hi Community,<BR /><BR />I'm working on a project that calculates a total of mix impact when comparing data between 2 selected periods. I have measures that calculate all of component, but I can't sum them up as a total. Is there a way to do it?<BR /><BR />Below is a mock data.</P><P> </P><P><U><STRONG>Fact Table</STRONG></U></P><TABLE border="1"><TBODY><TR><TD>Period ID</TD><TD>State</TD><TD>Type</TD><TD>Type</TD></TR><TR><TD>1</TD><TD>CA</TD><TD>Volume</TD><TD>10000</TD></TR><TR><TD>1</TD><TD>CA</TD><TD>Cost</TD><TD>50000</TD></TR><TR><TD>1</TD><TD>NY</TD><TD>Volume</TD><TD>1500</TD></TR><TR><TD>1</TD><TD>NY</TD><TD>Cost</TD><TD>15000</TD></TR><TR><TD>2</TD><TD>CA</TD><TD>Volume</TD><TD>8000</TD></TR><TR><TD>2</TD><TD>CA</TD><TD>Cost</TD><TD>45000</TD></TR><TR><TD>2</TD><TD>NY</TD><TD>Volume</TD><TD>3000</TD></TR><TR><TD>2</TD><TD>NY</TD><TD>Cost</TD><TD>20000</TD></TR><TR><TD>2</TD><TD>TX</TD><TD>Volume</TD><TD>1000</TD></TR><TR><TD>2</TD><TD>TX</TD><TD>Cost</TD><TD>6000</TD></TR><TR><TD>3</TD><TD>NY</TD><TD>Volume</TD><TD>2500</TD></TR><TR><TD>3</TD><TD>NY</TD><TD>Cost</TD><TD>10000</TD></TR><TR><TD>3</TD><TD>TX</TD><TD>Volume</TD><TD>1000</TD></TR><TR><TD>3</TD><TD>TX</TD><TD>Cost</TD><TD>5000</TD></TR></TBODY></TABLE><P> </P><P>User will use 2 slicers to select data for a comparison. These slicers are Period ID. Let's say a user select peiord 1 in slicer #1 and period 2 in slicer #2</P><P> </P><P>The calculation logics:</P><P> </P><TABLE border="1"><TBODY><TR><TD>Period 1</TD></TR><TR><TD>State</TD><TD>Vol</TD><TD>Cost</TD><TD>Avg</TD></TR><TR><TD>CA</TD><TD>10000</TD><TD>50000</TD><TD>5</TD></TR><TR><TD>NY</TD><TD>1500</TD><TD>15000</TD><TD>10</TD></TR><TR><TD>TX</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Total</TD><TD>11500</TD><TD>65000</TD><TD>5.652174</TD></TR></TBODY></TABLE><P> </P><TABLE border="1"><TBODY><TR><TD>Period 2</TD></TR><TR><TD>State</TD><TD>Vol</TD><TD>Cost</TD><TD>Avg</TD></TR><TR><TD>CA</TD><TD>8000</TD><TD>45000</TD><TD>5.625</TD></TR><TR><TD>NY</TD><TD>3000</TD><TD>20000</TD><TD>6.666667</TD></TR><TR><TD>TX</TD><TD>1000</TD><TD>6000</TD><TD>6</TD></TR><TR><TD>Total</TD><TD>12000</TD><TD>71000</TD><TD>5.916667</TD></TR></TBODY></TABLE><P> </P><P>First we find a total of Volume, Cost, and Average for each period. Here are the measures </P><DIV><DIV><SPAN>[Volume Sel 1] >> a total volume of each state</SPAN></DIV><DIV><DIV><SPAN>[Total Volume Sel 1] >> a total volume of all state in a period<BR />[Avg Cost Sel 1] >> an average cost of each state</SPAN></DIV><DIV><SPAN>[Total Avg Cost Sel 1] >> an average cost of all state in a period</SPAN></DIV><DIV> </DIV><DIV>selection #2 has the same measures</DIV></DIV></DIV><P> </P><P>Now, we have to find a percentage of a volume from each state comparing to a total of all state in a period. Then, we find what a percentage change of each state between 2 period </P><P> </P><TABLE border="1"><TBODY><TR><TD>Vol %</TD></TR><TR><TD>State</TD><TD>Period 1</TD><TD>Period 2</TD><TD>Chg</TD></TR><TR><TD>CA</TD><TD>0.8695652</TD><TD>0.666666667</TD><TD>-0.2029</TD></TR><TR><TD>NY</TD><TD>0.1304348</TD><TD>0.25</TD><TD>0.119565</TD></TR><TR><TD>TX</TD><TD>0</TD><TD>0.083333333</TD><TD>0.083333</TD></TR><TR><TD>Total</TD><TD>1</TD><TD>1</TD><TD>0</TD></TR></TBODY></TABLE><P> </P><P>Once we have a percentage different of each state, we will each state volume impact. To do this, we use a percentage different multiply by a total volume of all state from period #1</P><P> </P><P>To find Avg cost Impact of each state, we use state cost average from period #1 subtract by a total average cost from period #1. Since TX didn't have an average cost in period #1, we use TX average cost from period #2 and subtract by a total average cost from period #1.</P><P> </P><TABLE border="1"><TBODY><TR><TD>Dol Impact</TD></TR><TR><TD>State</TD><TD>Vol Impact</TD><TD>Avg Impact</TD><TD> </TD></TR><TR><TD>CA</TD><TD>-2333.3333</TD><TD>-0.65217391</TD><TD>1521.739</TD></TR><TR><TD>NY</TD><TD>1375</TD><TD>4.347826087</TD><TD>5978.261</TD></TR><TR><TD>TX</TD><TD>958.33333</TD><TD>0.347826087</TD><TD>333.3333</TD></TR><TR><TD>Total</TD><TD> </TD><TD> </TD><TD><FONT color="#339966">7833.333</FONT></TD></TR></TBODY></TABLE><P> </P><P>Once we have both Vol Impact and Avg Impact, we will calculate Dol Impact by multiply Vol Impact by Avg Impact then sum all of state Dol Impact to get our total Dol Impact. <BR /><BR />Here is my Dol Impact measure code</P><P> </P><P>Dol Impact = </P><DIV><DIV><SPAN>VAR Vol1_Pct = [Volume Sel 1] / [Total Volume Sel 1] </SPAN></DIV><DIV><SPAN>VAR Vol2_Pct = [Volume Sel 2] / [Total Volume Sel 2]</SPAN></DIV><DIV><SPAN><SPAN>VAR Pct_Diff = Vol1_Pct - Vol2_Pct<BR /></SPAN></SPAN><DIV><SPAN><SPAN>VAR Vol_Impact = Pct_Diff * [Total Volume Sel 1]<BR /></SPAN></SPAN><DIV><DIV><SPAN>VAR AvgCost_Impact =</SPAN></DIV><DIV class="lia-indent-padding-left-30px"><SPAN>IF([Volume Sel 1] <> 0, [<SPAN>Avg Cost Sel 1</SPAN>], [<SPAN>Avg Cost Sel 2</SPAN></SPAN><SPAN>) - IF([Total Volume Sel 1] <> 0, [Total <SPAN>Avg Cost Sel 1</SPAN>], [Total <SPAN>Avg Cost Sel 2</SPAN>])</SPAN></DIV><DIV><DIV><DIV><SPAN>VAR Dollar_Impact = Vol_Impact * AvgCost_Impact</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>Dollar_Impact</SPAN></DIV><DIV> </DIV><DIV><SPAN>So, when I put this Dol Impact measure in a Matrix table with State as rows, it displays each state dollar impact correctly, but the total line shows 0. My goal is to display a total dollar impact as a card. As of right now, it shows 0 as a total dollar impact as a card. </SPAN></DIV><DIV> </DIV><DIV><SPAN>Is there a way to sum each state dollar impact up and display as one value? Please help! Thank you for your time.</SPAN></DIV></DIV></DIV></DIV></DIV></DIV></DIV>Fri, 24 Jul 2020 17:47:55 GMThttps://community.powerbi.com/t5/Desktop/Need-help-calculating-a-cumulative-sum-of-measures/m-p/1249173#M551259Maxemus20002020-07-24T17:47:55ZRe: Need help calculating a cumulative sum of measures?
https://community.powerbi.com/t5/Desktop/Need-help-calculating-a-cumulative-sum-of-measures/m-p/1250065#M551550
<P>Hi <LI-USER uid="248286"></LI-USER> </P><P> </P><P>When you want a measure calculated at a certain granularity then summed, I would normally use SUMX.</P><P>The first argument of SUMX should be a table containing rows representing the granularity of the calculation (in your case State), and the second argument should be the calculation itself.</P><P> </P><P>In your case, you have a couple of options:</P><P> </P><P>1. Write another measure than sums the original measure by State, and use this new measure in your visuals:</P><LI-CODE lang="markup">Dol Impact Summed by State =
SUMX (
VALUES ( FactTable[State] ),
[Dol Impact]
)</LI-CODE><P> </P><P>2. Rewrite the original measure so that it sums by State:</P><LI-CODE lang="markup">Dol Impact =
SUMX (
VALUES ( FactTable[State] ),
VAR Vol1_Pct = [Volume Sel 1] / [Total Volume Sel 1]
VAR Vol2_Pct = [Volume Sel 2] / [Total Volume Sel 2]
VAR Pct_Diff = Vol1_Pct - Vol2_Pct
VAR Vol_Impact = Pct_Diff * [Total Volume Sel 1]
VAR AvgCost_Impact =
IF ( [Volume Sel 1] <> 0, [Avg Cost Sel 1], [Avg Cost Sel 2] )
- IF ( [Total Volume Sel 1] <> 0, [Total Avg Cost Sel 1], [Total Avg Cost Sel 2] )
VAR Dollar_Impact = Vol_Impact * AvgCost_Impact
RETURN
Dollar_Impact
)</LI-CODE><P>Notes:</P><OL><LI>In this situation, the 2nd argument of SUMX should either consist of measures or be wrapped in CALCULATE (in order to trigger context transition so that State is applied as a filter). As far as I can see, all values calculated that would depend on the State filter are already measures so I think there is no need to add an explicit CALCULATE.</LI><LI>Also, I can see that you might want to consider declaring a few extra variables to avoid repeated calculation of some of the sub-measures.</LI></OL><P>Regards,</P><P>Owen</P>Sat, 25 Jul 2020 14:35:01 GMThttps://community.powerbi.com/t5/Desktop/Need-help-calculating-a-cumulative-sum-of-measures/m-p/1250065#M551550OwenAuger2020-07-25T14:35:01ZRe: Need help calculating a cumulative sum of measures?
https://community.powerbi.com/t5/Desktop/Need-help-calculating-a-cumulative-sum-of-measures/m-p/1253304#M552512
<P><LI-USER uid="6799"></LI-USER>,<BR />Thank you for your help! I used option #1and it works great. I was previously trying to do SUMX after the return in Dol Impact measure calculation and it didn't work. Maybe I used the state component from a different table (rookie mistake).</P><P><BR />I have one more question, if you don't mind answering. Instead of State details, what if I want to do State and Store details? What do I need to add/change when I calculate the total sum using SUMX? </P>Mon, 27 Jul 2020 17:08:40 GMThttps://community.powerbi.com/t5/Desktop/Need-help-calculating-a-cumulative-sum-of-measures/m-p/1253304#M552512Maxemus20002020-07-27T17:08:40ZRe: Need help calculating a cumulative sum of measures?
https://community.powerbi.com/t5/Desktop/Need-help-calculating-a-cumulative-sum-of-measures/m-p/1253803#M552645
<P><LI-USER uid="248286"></LI-USER> </P><P>That's good news <span class="lia-unicode-emoji" title=":slightly_smiling_face:">ðŸ™‚</span></P><P> </P><P>If you have State & Store defining your granularity, I would usually use SUMMARIZE to create a table of existing combinations and SUMX over that:</P><P> </P><LI-CODE lang="markup">Dol Impact Summed by State =
SUMX (
SUMMARIZE( FactTable, FactTable[State], FactTable[Store] ),
[Dol Impact]
)</LI-CODE><P>Notes:</P><UL><LI>State & Store can be either in FactTable itself or in tables on the 1-side of a relationship with FactTable.</LI><LI>Another option is to use nested SUMXs over each dimension in turn: <STRONG>SUMX ( VALUES(...), SUMX ( VALUES(...), [Dol Impact] ) )</STRONG></LI></UL><P>Regards,</P><P>Owen <span class="lia-unicode-emoji" title=":slightly_smiling_face:">ðŸ™‚</span></P><P> </P>Mon, 27 Jul 2020 21:59:32 GMThttps://community.powerbi.com/t5/Desktop/Need-help-calculating-a-cumulative-sum-of-measures/m-p/1253803#M552645OwenAuger2020-07-27T21:59:32ZRe: Need help calculating a cumulative sum of measures?
https://community.powerbi.com/t5/Desktop/Need-help-calculating-a-cumulative-sum-of-measures/m-p/1256085#M553299
<P class="lia-align-left"><LI-USER uid="6799"></LI-USER> <BR />Thanks again for helping. I used nested SUMX and it gave me "NaN" as a result. I guess there might be some calculation error somewhere. <BR />On another hand, I have tried the SUMMARIZE solution you have provided, it gave me 0 as a total. Does this related to the "calculation error"? <BR /><BR />Also, can you educate me on why do I need to create another measure to calculate Total Dollar? I tried adding the same SUMX statement after RETURN in the Dol Impact and it gave me 0 instead of the total. </P>Tue, 28 Jul 2020 14:03:18 GMThttps://community.powerbi.com/t5/Desktop/Need-help-calculating-a-cumulative-sum-of-measures/m-p/1256085#M553299Maxemus20002020-07-28T14:03:18ZRe: Need help calculating a cumulative sum of measures?
https://community.powerbi.com/t5/Desktop/Need-help-calculating-a-cumulative-sum-of-measures/m-p/1256996#M553574
<P>Got the NaN error taking care of. </P><P> </P><P>Some of the data were blank and PBI doesn't like it when I do "A / B". So, I used DIVIDE(A, B, 0) instead. </P>Tue, 28 Jul 2020 18:43:40 GMThttps://community.powerbi.com/t5/Desktop/Need-help-calculating-a-cumulative-sum-of-measures/m-p/1256996#M553574Maxemus20002020-07-28T18:43:40ZRe: Need help calculating a cumulative sum of measures?
https://community.powerbi.com/t5/Desktop/Need-help-calculating-a-cumulative-sum-of-measures/m-p/1257491#M553719
<P>That's good <span class="lia-unicode-emoji" title=":slightly_smiling_face:">ðŸ™‚</span><BR />Is the SUMMARIZE method still giving a zero result?</P><P>To debug, I would create a table or matrix visual with both State & Store, plus the final measure using SUMMARIZE.</P><P>The individual measure values should sum to the total, and you will be able to see why they are offsetting to zero.</P>Wed, 29 Jul 2020 00:49:21 GMThttps://community.powerbi.com/t5/Desktop/Need-help-calculating-a-cumulative-sum-of-measures/m-p/1257491#M553719OwenAuger2020-07-29T00:49:21ZRe: Need help calculating a cumulative sum of measures?
https://community.powerbi.com/t5/Desktop/Need-help-calculating-a-cumulative-sum-of-measures/m-p/1259496#M554293
<P>Yes, the summerize is still giving me 0. I put this in a matrix table and it shows all 0. </P><P> </P><DIV><DIV><SPAN>Test = </SPAN></DIV><DIV><SPAN>SUMX(SUMMARIZE('Volume', 'Volume'[State], 'Volume'[Store]), 'Impact'[Dol Impact])</SPAN></DIV></DIV>Wed, 29 Jul 2020 14:30:23 GMThttps://community.powerbi.com/t5/Desktop/Need-help-calculating-a-cumulative-sum-of-measures/m-p/1259496#M554293Maxemus20002020-07-29T14:30:23ZRe: Need help calculating a cumulative sum of measures?
https://community.powerbi.com/t5/Desktop/Need-help-calculating-a-cumulative-sum-of-measures/m-p/1261807#M554970
<P>Thanks, not sure what's causing that, something in the logic of the [Dol Impact] calculation.</P><P>Can you share a sample pbix file (with sanitised data if needed) that shows this problem?</P><P>Regards,</P><P>Owen</P>Thu, 30 Jul 2020 10:51:37 GMThttps://community.powerbi.com/t5/Desktop/Need-help-calculating-a-cumulative-sum-of-measures/m-p/1261807#M554970OwenAuger2020-07-30T10:51:37ZRe: Need help calculating a cumulative sum of measures?
https://community.powerbi.com/t5/Desktop/Need-help-calculating-a-cumulative-sum-of-measures/m-p/1264980#M555825
<P>Unfortunately, due to time crunch and data privacy, I can't share my original .pbix file and don't have enough time to replicate it with a mock data. The example is pretty much using the exact calculation I provided. As for now, the nested SUMX got the job done. I will look around for a the SUMMRIZE solution when I have time. Thank you for all of your help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">ðŸ™‚</span></P>Fri, 31 Jul 2020 13:27:56 GMThttps://community.powerbi.com/t5/Desktop/Need-help-calculating-a-cumulative-sum-of-measures/m-p/1264980#M555825Maxemus20002020-07-31T13:27:56Z