Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create a measure based on a filtered value

I feel like this should be easy and maybe my brain is just fried today.   I am trying to show my list of projects and the Decision Points Values in a table. However - the Decision points currently ...
Need Help
  • fhill's avatar
    fhill
    5 years ago

    Can you use the simplier version of the formula below?  Or, do you have to have 'Values' instead of MAX?

    Gate A = CALCULATE( MAX(Projects[Actual/Trend]), Projects[Gate] = "A")
     
     

fhill's avatar
fhill
Icon for Resident Rockstar rankResident Rockstar
5 years ago

Can you use the simplier version of the formula below?  Or, do you have to have 'Values' instead of MAX?

Gate A = CALCULATE( MAX(Projects[Actual/Trend]), Projects[Gate] = "A")
 
 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Not Attached to Values 🙂 Just thought that was the right thing to use! Thanks so much, this worked great.