Percentage within table per row

[Jamesfindog]

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: 

Total Activity Status =

DISTINCTCOUNT('Activities'[Activity ID])

Thanks for your help.

[MasonMA · Accepted solution]

@Jamesfindog 

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:) 

[Jamesfindog]

Thank you mate, massively appreciated! 🙂