Calculating total hours over a threshold

[JoeKat07]

Im trying to find if there are time entries that add up to going over an allotted amount of time (threshold). ive calculated the total hours of the projects by using a measure with the equation TotalHours = sum('Test Table'[Hours]). I need to show the calculate the difference between the two values. Here is the table i'm working with.

Thanks!!!

[Anonymous]

Here is my suggestion.  Create a Matrix Visual.  Put your project ID onto the Rows and create this measure which will be your "Values".  Then filter out when Values is less or equal to 0.

Hours over =  MEDIAN('YourTable'[Threshold]) - SUM('Your Table'[Hours])

[v-huizhn-msft · Accepted solution]

Hi @JoeKat07,

Based on my understanding, please follow the steps and check if it meets your requirement.

1. You can create a new table using SUMMARIZE function by New Table under Modeling on home page->type the following formula.

Table = SUMMARIZE(Test,Test[Project Id],"TotalHours",SUM(Test[Threshold]))

2. Create the calculated columns using the formulas.

previous row = LOOKUPVALUE('Table'[TotalHours],'Table'[Project Id],'Table'[Project Id]-1)

difference = 'Table'[TotalHours]-'Table'[previous row]

Best Regards,
Angelia