Max Forecast for ALL periods by Project

[Jdokken]

Hello- 

I'm trying to find a calculation that will look through ALL periods for each project (ignoring filters on the visual) and bring back the MAX Group Margin Fcst for each project so that I can then divide it by the most current Group Margin Fcst. Here's what I have so far and it's just bringing back the Group Margin Forecast.  In this example it should be bringing back 4,910 in the -GMF Change Max column. 

Project Name	Project #	GL Period	Group Margin Fcst	GMF Change Max
Village	1419145	19-Nov	4,910	4,910
Village	1419145	19-Dec	4,910	4,910
Village	1419145	20-Jan	4,910	4,910
Village	1419145	20-Feb	4,910	4,910
Village	1419145	20-Mar	4,910	4,910
Village	1419145	20-Apr	4,637	4,637
Village	1419145	20-May	4,637	4,637
Village	1419145	20-Jun	4,644	4,644
Village	1419145	20-Jul	4,646	4,646
Village	1419145	20-Aug	4,646	4,646
Village	1419145	20-Sep	3,354	3,354
Village	1419145	20-Oct	3,265	3,265
Village	1419145	20-Nov	1,975	1,975
Village	1419145	20-Dec	1,932	1,932
Village	1419145	21-Jan	1,932	1,932
Village	1419145	21-Feb	1,932	1,932
Village	1419145	21-Mar	1,664	1,664
Village	1419145	21-Apr	1,096	1,096
Village	1419145	21-May	439	439
Village	1419145	21-Jun	306	306

[selimovd]

Hey @Jdokken ,

the combination of CALCULATE and MAXX doesn't work like this. But you can just use the MAXX of the complete table. Try the following approach:

GMF Change Max =
MAXX(
    ALL( 'Internal Financial Metrics' ),
    'Internal Financial Metrics'[Group Margin Fcst]
)

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Jdokken]

@selimovd Thanks for your response Denis. I think we are missing the Project # from this calculation (Which I don't think I identified clearly above) as this calcuation brings back the max Group Margin forecast in the whole data set vs by Project. 

[selimovd · Accepted solution]

Hey @Jdokken ,

yeah, makes it easier when you mention all the details.

In this case try it with an ALLEXCEPT:

GMF Change Max =
MAXX(
    ALLEXCEPT( 'Internal Financial Metrics', 'Internal Financial Metrics'[Project #] ),
    'Internal Financial Metrics'[Group Margin Fcst]
)

Like this it will return the MAX per Project number when the filter context contains a project number.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Jdokken]

@selimovd Great, this works for most of my projects.  We break down certain projects even further and then on each page we choose which "View" we want to see and it grabs the corresponding rows for those projects. So I need to figure out how to add that filter onto this measure. Those filters are in a different table but joined to the "Internal Financial Metrics" table.