Forum Discussion

PaulDenne's avatar
PaulDenne
Helper I
2 years ago
Solved

table filter

Hi I am new to Power bi I have a table filtering weekly hours for all staff from daily timesheets into weeks using a date table to get week numbers and sum the hours for the week, and currently hig...
  • lbendlin's avatar
    lbendlin
    2 years ago

    Use a "What-if"  numeric parameter for that.

PaulDenne's avatar
PaulDenne
Helper I
2 years ago

Hi solved the last step by creating a Measure for Weekly hours current week

Weekly Hours = CALCULATE(SUM('Detailed - Timesheet Report'[Regular Hours]), ALLEXCEPT('Detailed - Timesheet Report', 'Detailed - Timesheet Report'[Name], 'Date'[Current week]) )
 
then populated Table with that measure
 
then created a filter based on your example 
Filter Weekly hours = if(MAXX('Detailed - Timesheet Report',[Weekly Hours])>('Work Limit'[Work Limit Value]),1,0)
 
so greatful for your help
lbendlin's avatar
lbendlin
Super User
2 years ago

You could also have included the week in the SUMMARIZE.