Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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" function should be 34.4% even if the function filter deselects "Construction" & "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.
I have used the below measure, with no luck:
% Function = DIVIDE([ProjectHrs],[AllProjectTotalHrs])
Data Table:
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 |
Any advise is much appreciated.
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |