Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Solution Sage
Solution Sage

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
Solution Sage
Solution Sage

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors