Forum Discussion
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
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
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