How To Sum up Rows One by One Until Reach Total?

[Mohammadwazeri]

Hi Guys,

I just come up with something I need your input on, I am not sure if there is something like Excel in Power BI.

This is done in Excel, 

In the screenshot below. The sum of Row 2, Column1 is 3.57% of the total of Column1($280).

Then sum of Rows 2 & 3 of Column1 is 10.71% of the total of Column1($280).

Then sum of Rows 2, 3, & 3 of Column1 is 21.43% of the total of Column1($280).

It keep adding rows one by one until it reach the total amount and 100%.

Thank you,

Mohammad

[Ashish_Mathur]

Hi,

What's important to know is the order in which the numbers should appear to calculate the running total.  Should the amounts be arranged in ascending order or should they be arranged in ascending/descending order of some other field (such as date, Product).  If you need further help, then share the download link of the PBI file with your Table/matrix visual already built.

[Greg_Deckler]

@Mohammadwazeri You basically need a running total but for that you need something to define "earlier". 

[SivaMani]

@Mohammadwazeri, This can be achieved with DAX Measure. Please refer the below URL
https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/