Forum Discussion

Jdokken's avatar
Jdokken
Icon for Helper III rankHelper III
5 years ago
Solved

Max Forecast for ALL periods by Project

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 c...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    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
     
selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

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
 
  • Jdokken's avatar
    Jdokken
    Icon for Helper III rankHelper III
    5 years ago

    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's avatar
      selimovd
      Icon for Most Valuable Professional rankMost Valuable Professional
      5 years ago

      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
       
      • Jdokken's avatar
        Jdokken
        Icon for Helper III rankHelper III
        5 years ago

        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.