title: How to calculate cumulative Total and % in DAX?
body: <p>This might be very simple... </p>
  
  <p>I have the below summary table in Power BI and need to build a Pareto Chart, what I'm looking for is a way to create columns "D" and "E"... Thanks in advance!</p>
  
  <p>The Count from column "B" is a measure I've created in PBI based on multiple filters. I've already tried some Calculate/Sum/Filter type of expressions with no luck. </p>
  
  <p><a href="https://i.stack.imgur.com/7uZon.png" rel="noreferrer"><img src="https://i.stack.imgur.com/7uZon.png" alt="enter image description here"></a></p>
  
  <p>My raw data looks like Image #2... I have the measures to build the summary table with the exception of column "I" - Running % - (for which I will also need the cumulative total of events per bucket).</p>
  
  <p>Unfortunately, I haven't been able to successfully apply the calculations from DAXPATTERNS.</p>
  
  <p><a href="https://i.stack.imgur.com/BashC.png" rel="noreferrer"><img src="https://i.stack.imgur.com/BashC.png" alt="enter image description here"></a></p>