Forum Discussion
Need help
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!
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?
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
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?