Forum Discussion

Frequent Visitor

9 years ago

Solved

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

Interesting Links

Tips and Tricks

MarkS
9 years ago
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
9 years ago
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

Resolver IV

9 years ago

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
Frequent Visitor
9 years ago
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
- MarkS
  Resolver IV
  9 years ago
  Hi,
  The formula calculates the threshold of each Project ID, year, and Quarter when put in a table visual with these values.
- v-huizhn-msft
  Microsoft Employee
  9 years ago
  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