- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
The formula calculates the threshold of each Project ID, year, and Quarter when put in a table visual with these values.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
01-16-2023 03:32 PM | |||
01-27-2025 12:45 AM | |||
12-15-2024 10:24 PM | |||
02-07-2025 07:43 AM | |||
10-17-2024 03:11 PM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |