Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Percentage Measure Difficulty in a Table

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:

 

NameCategoryTime SpentPercentage
SarahReports40100%
JackProject1012.50%
JackMeetings3037.50%
JackReports2531.25%
JackTraining1518.75%
EmmaMeetings2550%
EmmaProject2550%

 

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

 

Thanks

Need Help
  • vicky_'s avatar
    vicky_
    2 years ago

    Try the below:

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

1 Reply

  • vicky_'s avatar
    vicky_
    Super User
    2 years ago

    Try the below:

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