Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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 ...
  • MasonMA's avatar
    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:)