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