% Column Total - Measure

Question

Hello - I am trying to replicate the "show value as....Percent of Column Total" as a "MEASURE".&nbsp;The measure should NOT change based on FILTERS i.e. for example in Project P1, "Administration" function should be 34.4% even if the function filter deselects "Construction" &amp; "Contracts"I need the measure to be able to plot this on a graph, hence the "show value as....Percent of Column Total" is not helpful when the data is filtered.&nbsp;I have used the below measure, with no luck:ProjectHrs = sum(Data[Total Hours])AllProjectTotalHrs =&nbsp;CALCULATE(sum(Data[Total Hours]),ALL(Data[Project]))% Function =&nbsp;DIVIDE([ProjectHrs],[AllProjectTotalHrs])&nbsp;&nbsp;&nbsp;Data Table:&nbsp;&nbsp;FUNCTIONP1&nbsp;P2P3&nbsp;Administration&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 155,494&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 91,306&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 79,080&nbsp;Construction&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 227,936&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 181,539&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 237,178&nbsp;Contracts&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 68,174&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 64,157&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 78,785Any advise is much appreciated.

alb · Accepted Answer

Hello @hackfifi
Maybe
AllProjectTotalHrs = CALCULATE(sum(Data[Total Hours]),ALL(Data[FUNCTION]) )

Please mark the resolved question when you are finished and consider giving a thumbs up if the posts are useful.
Contact me privately for assistance with any large-scale BI needs, tutoring, etc.
Bless you

Forum Discussion

% Column Total - Measure

1 Reply

Related content

% of total measure

Total of Measure

Total Value Column Measure

Total Count in Column

Problem with Total in column (measures)

FUNCTION	P1	P2	P3
Administration	155,494	91,306	79,080
Construction	227,936	181,539	237,178
Contracts	68,174	64,157	78,785