Over threshold by quarter

[JoeKat07]

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

 

[MarkS · Accepted solution]

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

[MarkS · Accepted solution]

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

[JoeKat07 · Accepted solution]

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

[v-huizhn-msft]

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

[MarkS]

Hi,

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