How to create a summary measure across multiple columns?

Question

Hello,&nbsp;&nbsp;I'm trying to create a dynamic measure that will provide with a total headcount across mutilple fields (columns). Please see image below for example:&nbsp;I would like a measure that would identify the total headcount for a given contractor or project. I've started with this measure :Measure_AS_Peak_HC = SUMX(SUMMARIZE(Table_Headcount,[Contractor],[Project],"Max HC", MAX(Table_Headcount[Headcount]),[Max HC])&nbsp;However, it's returning the MAX HC of a contractor for a single project rather than giving me a max hc for a contractor across all projects, if that makes sense?

vapid128 · Answer

Can you just tell what number you tring to get?max headcount of contractor of e? 141?

saavedrag12 · Answer

I'm trying to get the total headcount that will then be adjusted when filters are applied to project and contractor.&nbsp;

vapid128 · Answer

Could you just show your result in excel?

v-zhangti · Answer

Hi,&nbsp;saavedrag12&nbsp;
&nbsp;
Please check the following methods.
Measure = 
CALCULATE (
    MAX ( Table_Headcount[Headcount] ),
    FILTER (
        ALL ( Table_Headcount ),
        [Contractor] = SELECTEDVALUE ( Table_Headcount[Contractor] )
    )
)

Is this the output you expect? If not, please tell the result you expect, showing it in pictures.
&nbsp;
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

saavedrag12 · Answer

Hello,&nbsp;The Calculate function does not allow me to utilize the filter function for the second argument.&nbsp;

Forum Discussion

How to create a summary measure across multiple columns?

6 Replies

Related content

Summary Columns in Matrix

Power BI July 2026 Feature Summary

Sequential Order column based on multiple criteria

Power BI October 2026 Feature Summary

Summary Visual from multiple columns