Forum Discussion

hackfifi's avatar
hackfifi
Helper V
5 years ago
Solved

% 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...
  • AlB's avatar
    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

    SU18_powerbi_badge