Need help

Question

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

anonymous · Answer

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

anonymous · Answer

jtremel,You can try this:Running % =CALCULATE (SUM ( Table[Percentage]),FILTER ( ALL (Table), Table[Transaction] &lt;= MAX ( Table[Transaction] ) ))You can replace Table with your table name. Hope this help!

jtremel · Answer

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?&nbsp;&nbsp;

jtremel · Answer

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&nbsp;in a month and the table have this columns code-date-hour of the trans-amountand inside the matrix i seleceted to show the sum of&nbsp;all the same codes and to show the&nbsp;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?

Forum Discussion

Need help

4 Replies