Forum Discussion
Percentage within table per row
- 1 year ago
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:)
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:)
Thank you mate, massively appreciated! 🙂