Need help

[jtremel]

Hello powerBi teammates i need help

In a powerBi visualization I have a column with percentages of the sum of a transaction type,
example
transaction 1   47%
transaction 2   23%
transaction 3   18%
transaction4     5%
transaction 5    4%
transaction 6    3%
Total               100%
I want to show this percentage but, that the sum is added to the previous value until completing 100% like this
T1    47%
T2    70%
T3    88%
T4    93%
T5    97%
T6   100%
how do i do that

[Anonymous]

@jtremel,

You can try this:

Running % =
CALCULATE (
SUM ( Table[Percentage]),
FILTER ( ALL (Table), Table[Transaction] <= MAX ( Table[Transaction] ) )
)

You can replace Table with your table name. Hope this help!

[jtremel]

this is the matrix where i want to see the sum of the percentages and i cannot do it on the table because in the table i have all the transaccions, how do i sum that % u see in the matrix?

[Anonymous]

I should clarify. Table should the name of your table in your data model.  For example, I click on New Measure on Home ribbon to create my measure: 

Running % =
CALCULATE (
SUM ( Sheet1[Percentage]),
FILTER ( ALL (Sheet1), Sheet1[Transaction] <= MAX ( Sheet1[Transaction] ) )
)

In this case, my table name is sheet1 because I get the data from an Excel file. Then, I just drag my measure to the matrix

[jtremel]

ok i understand that but in the table i have all the information i don't have the transaccions compiled like u, i just have all the transaccions made in a month and the table have this columns code-date-hour of the trans-amount

and inside the matrix i seleceted to show the sum of all the same codes and to show the value by % of the total should i create another table to get the information like u or in this case is another form to do it?