Forum Discussion
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 exist in a table like this below and I want them to show in a column, so I thought all I needed to do was create a measure to show them. I CANNOT get this measure to function the way I want it to.
Table I'm creating:
| Project | Schedule Health | Revenue | Expenditures | Budget | Gate A | Gate B |
| Project 1 | X | X | X | X | 1/1/2020 | 1/1/2021 |
| Project 2 | X | X | X | X | 1/1/2020 | 5/6/2020 |
| Project 3 | X | X | X | X | 5/1/2020 | 12/31/2020 |
The Gates currently exist in the columns:
"Gate" and "Actual/Trend"
| Gate | Actual/Trend | Project |
| A | 1/1/2020 | Project 1 |
| B | 1/1/2021 | Project 1 |
| C | Project 1 | |
| D | Project 1 |
I thought this would work:
Gate A = CALCULATE(VALUES('PP - Project Status AIM'[Actual/Trend]), FILTER('PP - Project Status AIM', 'PP - Project Status AIM'[DP] = "DP-A"))
but it shows a measure with errors and then just says "Can't display visual" when I try to use it
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")
2 Replies
- fhill
Resident Rockstar
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")