Calculating Average in Total Line

[chrismoncrief]

I am sure this is something simple that I am missing, but I have created reports that have the total line enabled on my report.  Each line in the report calcuates an percentage for the line.  However, in the totals line all the options I find either sum the percentages, or gives me an average of all the percentages.  

Above is an example from the report.  What I am looking for in the total line is for it to display the percentage of $15,444.84/$28,625.15.  The only options I have found gives me a total of 164.72% summing the two numbers, or 82.36% which is then the average of the two numbers.  Nothing I have found would display the total as 53.95%.  Any help would be appreciated.

[shafiz_p]

Hi @chrismoncrief  The following measure should work. Please try this below code:

Total Percentage = 
DIVIDE(
    SUM('YourTable'[NumeratorColumn]),
    SUM('YourTable'[DenominatorColumn])
)

If the problem still exist, kindly provide sample data and your expected result to get the exact solution.

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

percentage measure: = 
DIVIDE( SUM(data[actual]), SUM(data[plan]) )