cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

2 ACCEPTED SOLUTIONS
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

Frequent Visitor

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

4 REPLIES 4
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

Frequent Visitor

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

Microsoft Employee

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

Resolver IV

Hi,

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

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

Top Solution Authors
Top Kudoed Authors