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

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

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.