A measure to get the sum of max FTE

amdg_utmost — Tue, 13 Dec 2022 16:23:35 GMT

Hi everyone,

I am looking for a measure "SumOfMaxFTE" that will Sum the Max of all [FTE] by [Name] and [Group].

Here is my source data having [Group], [Name], [Date], and [FTE]

Summarizing the above by [Group], [Name], and Max([FTE]), I get the following

Summarizing the above further by [Group] and Sum(Max of FTE), I get the following

Thank you in advance for your help in coming up with a SumOfMaxOfFTE measure.

Here is the datasource in text

Cheers and God bless!

Re: A measure to get the sum of max FTE

PaulOlding — Tue, 13 Dec 2022 17:49:02 GMT

You could use a measure like this:

Max of FTE = SUMX( SUMMARIZE('FTE Table', 'FTE Table'[Group], 'FTE Table'[Name]), CALCULATE(MAX('FTE Table'[FTE])) )

That can be used in both of your visuals:

amdg_utmost — Tue, 13 Dec 2022 22:07:17 GMT

Works, thanks PaulOlding !