Power Bi Table Total Percentage

Question

Hello everyone, I need assistance as I am having issues with the total field in a table using percentage.&nbsp;&nbsp;I have data that looks like&nbsp;&nbsp;Data Previous Year | Data Current Year | Percent Change10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-50%10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-50%---Total: 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -100%&nbsp;&nbsp;Clearly, I want the total to show -50% is that is the percent change for the total rather than the sum of the entries. How can I do this. Thank you so much!

speedramps · Accepted Answer

use SUMX which iterates the calculation for each row
&nbsp;
eg&nbsp; &nbsp;SUMX(yourtablename,[yout percent measure name]
&nbsp;
See this video&nbsp;
&nbsp;
please click the thumbs up and accept as solution buttons. Thanks&nbsp;😀
&nbsp;

Forum Discussion

Power Bi Table Total Percentage

1 Reply

Related content

Power BI tables with percentages

Percentage by group

Converting to Percentage

Calculate percentage from two Tables

Matrix table in Power bi