cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

## A measure to get the sum of max FTE

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

 Name Group Date FTE Kory Campbell Group 01 9/09/2022 0.9 Kory Campbell Group 01 16/09/2022 0.8 Kory Campbell Group 01 23/09/2022 0.6 Kory Campbell Group 01 30/09/2022 0.9 Wilbur Jackson Group 01 9/09/2022 0.1 Wilbur Jackson Group 01 16/09/2022 0.4 Wilbur Jackson Group 01 23/09/2022 0.4 Wilbur Jackson Group 01 30/09/2022 0.6 Wilbur Jackson Group 01 7/10/2022 0.7 Wilbur Jackson Group 02 9/09/2022 0.8 Wilbur Jackson Group 02 16/09/2022 0.6 Wilbur Jackson Group 02 23/09/2022 0.4 Wilbur Jackson Group 02 30/09/2022 0.4 Wilbur Jackson Group 02 7/10/2022 0.2 Kelsey Hubert Group 02 9/09/2022 0.1 Kelsey Hubert Group 02 16/09/2022 0.1 Lyda Grant Group 01 9/09/2022 0.8 Lyda Grant Group 01 16/09/2022 1 Lyda Grant Group 01 23/09/2022 0.8 Lyda Grant Group 01 7/10/2022 0.8

Cheers and God bless!

1 ACCEPTED SOLUTION
Solution Sage

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:

2 REPLIES 2
Solution Sage

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:

Frequent Visitor

Works, thanks @PaulOlding !

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors