Reply
JoeKat07
Frequent Visitor

Over threshold by quarter

i'm trying to find if a client goes over a threshold of hours by quarter. Here is the table i'm working with. I'm completely lost on this one

 image.png

2 ACCEPTED SOLUTIONS
MarkS
Resolver IV
Resolver IV

Hi,

Try creating this measure

Over/Under Threshold = if(SUM(Table1[Hours])>MAX(Table1[Threshold]),"Over","Under")

Add it to a table visual and filter the Over/Under Threshold to contains Over

View solution in original post

Close, but if you look carefully each of the project id's have a different threshold. I need it to be calculated for each individual threshold

View solution in original post

4 REPLIES 4
MarkS
Resolver IV
Resolver IV

Hi,

Try creating this measure

Over/Under Threshold = if(SUM(Table1[Hours])>MAX(Table1[Threshold]),"Over","Under")

Add it to a table visual and filter the Over/Under Threshold to contains Over

Close, but if you look carefully each of the project id's have a different threshold. I need it to be calculated for each individual threshold

Hi @JoeKat07,

You have resolved your issue? If not, you'd better list the expected result in an example. So that we can post the solution which is close to your requirement.

Thanks.
Angelia

Hi,

The formula calculates the threshold of each Project ID, year, and Quarter when put in a table visual with these values.SS06052017.PNG

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)