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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
enswitzer
Helper III
Helper III

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:

 

ProjectSchedule HealthRevenueExpendituresBudgetGate AGate B
Project 1XXXX1/1/20201/1/2021
Project 2XXXX1/1/20205/6/2020
Project 3XXXX5/1/202012/31/2020

 

The Gates currently exist in the columns:

 

"Gate" and "Actual/Trend"

 

GateActual/TrendProject
A1/1/2020Project 1
B1/1/2021Project 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 

 

 

1 ACCEPTED SOLUTION
fhill
Resident Rockstar
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")
 
 

image.png




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




View solution in original post

2 REPLIES 2
fhill
Resident Rockstar
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")
 
 

image.png




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




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

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.