Forum Discussion
Percentage within table per row
Hi,
Having a bit of a brain-fart here.
I have the below table:
| Activity Status Name | Total Activity Status |
| Awaiting Sign-off | 2 |
| Complete | 186 |
| In Progress | 76 |
| Not Started | 413 |
| On Hold | 8 |
And I am trying to add a percentage of total column like:
| Activity Status Name | Total Activity Status | percentage of total |
| Awaiting Sign-off | 2 | 0% |
| Complete | 186 | 27% |
| In Progress | 76 | 11% |
| Not Started | 413 | 60% |
| On Hold | 8 | 1% |
"Total Activity Status" is a measure which is:
Anonymous
Hi, to add a "Percentage of Total" column alongside your Total Activity Status measure, you would need to create a new measure that calculates the proportion of each status relative to the total across all statuses.
% of Total Activity Status = DIVIDE( [Total Activity Status], CALCULATE([Total Activity Status], ALL('Activities'[Activity Status Name])) )Also, to validate the DAX measure output, ideally you would need to provide complete underlying data (i.e., all records from the 'Activities' table or a sufficient sample). This would help other users to give you a fully functional Measure.
Hope this helps:)
2 Replies
- MasonMA
Super User
Anonymous
Hi, to add a "Percentage of Total" column alongside your Total Activity Status measure, you would need to create a new measure that calculates the proportion of each status relative to the total across all statuses.
% of Total Activity Status = DIVIDE( [Total Activity Status], CALCULATE([Total Activity Status], ALL('Activities'[Activity Status Name])) )Also, to validate the DAX measure output, ideally you would need to provide complete underlying data (i.e., all records from the 'Activities' table or a sufficient sample). This would help other users to give you a fully functional Measure.
Hope this helps:)