cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amdg_utmost
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]

image1.png

 

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

image2.png

 

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

image3.png

 

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

 

Here is the datasource in text

NameGroupDateFTE
Kory CampbellGroup 019/09/20220.9
Kory CampbellGroup 0116/09/20220.8
Kory CampbellGroup 0123/09/20220.6
Kory CampbellGroup 0130/09/20220.9
Wilbur JacksonGroup 019/09/20220.1
Wilbur JacksonGroup 0116/09/20220.4
Wilbur JacksonGroup 0123/09/20220.4
Wilbur JacksonGroup 0130/09/20220.6
Wilbur JacksonGroup 017/10/20220.7
Wilbur JacksonGroup 029/09/20220.8
Wilbur JacksonGroup 0216/09/20220.6
Wilbur JacksonGroup 0223/09/20220.4
Wilbur JacksonGroup 0230/09/20220.4
Wilbur JacksonGroup 027/10/20220.2
Kelsey HubertGroup 029/09/20220.1
Kelsey HubertGroup 0216/09/20220.1
Lyda GrantGroup 019/09/20220.8
Lyda GrantGroup 0116/09/20221
Lyda GrantGroup 0123/09/20220.8
Lyda GrantGroup 017/10/20220.8

 

Cheers and God bless!

1 ACCEPTED SOLUTION
PaulOlding
Super User
Super User

Hi @amdg_utmost 

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:

PaulOlding_0-1670953716259.png

 

View solution in original post

2 REPLIES 2
PaulOlding
Super User
Super User

Hi @amdg_utmost 

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:

PaulOlding_0-1670953716259.png

 

Works, thanks @PaulOlding !

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors