Forum Discussion
hackfifi
5 years agoHelper V
% Column Total - Measure
Hello - I am trying to replicate the "show value as....Percent of Column Total" as a "MEASURE". The measure should NOT change based on FILTERS i.e. for example in Project P1, "Administration" funct...
- 5 years ago
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
AlB
5 years agoCommunity Champion
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