Calculate a value as a percentage of another

[jamesclark458]

Hi folks,

Apologies for the post, I wasn't able to find a solution in the community that worked for my particular scenario. 

I have a table that helps me track cross-charging in my team so I can understand how much time we cross-charge other teams for.

Total Hours	Total Hours Recharged
10,836	3,056
This is the sum of column 'Table1'[Total Hrs]	The measure for this is calculating the sum of 'Table1'[Total Hrs] where colum 'Table1'[Type] is equal to "Recoverable"

I want to create a measure that shows the Total Hours Recharged as a percentage of Total Hours, but I don't think I can use a measure within another measure to make that happen. 

The end results should be a measure that gives me a result of circa 28%

Any ideas would be greatly appreciated 🙂 

[ddpl]

@jamesclark458  try this,

Percentage M = ROUND(DIVIDE([Total hours Recharged],[Total Hours]),2)*100 & "%"

[jamesclark458]

Hi @ddpl 

Thanks for the advice, a previous post managed to resolve my issue just before I saw your comment come in, but thank you all the same. Its always handy to have a couple of options 🙂

[johnt75 · Accepted solution]

You can use measures inside another measure, so you could do

Total hours recharged % = DIVIDE( [Total hours recharged], [Total hours] )

[jamesclark458]

Thank you for this @johnt75 

I need to create a measure for Total Hours, but this has worked and given me the result I needed 🙂