Percentage Measure Difficulty in a Table

[Shawkins566]

Hi,

I have timesheets and they are broken down by Name, Category and Time Spent, I am trying to show in a table format what the percentage of each person's total time is being spent on each Category.  This is an example of what I want it to look like below:

Name	Category	Time Spent	Percentage
Sarah	Reports	40	100%
Jack	Project	10	12.50%
Jack	Meetings	30	37.50%
Jack	Reports	25	31.25%
Jack	Training	15	18.75%
Emma	Meetings	25	50%
Emma	Project	25	50%

I can't seem to work it out, if anyone knows how, please let me know.

Thanks

[vicky_ · Accepted solution]

Try the below:

Percentage = 
var totalTimePerName = CALCULATE(SUM('Table'[Time Spent]), REMOVEFILTERS('Table'[Category])) 
return DIVIDE(SUM('Table'[Time Spent]), totalTimePerName)