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

think I see the issue my work table didnt generate the 30-60 range

lbendlin's avatar
lbendlin
Super User
2 years ago

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

  • PaulDenne's avatar
    PaulDenne
    Helper I
    2 years ago

    many thanks, didn't cover that in my 1 day tutorial 

  • PaulDenne's avatar
    PaulDenne
    Helper I
    2 years ago

    so last step ..hopefully

    I replaced names with my tables and when I add the show filter not data comes for any value, so I have messed up somewhere addin the measuer?

    Show =
    var a = SUMMARIZE('Detailed - Timesheet Report',[Name])
    var b = ADDCOLUMNS(a,"mx",max('Detailed - Timesheet Report'[Regular Hours]))
    return if(maxx(b,[mx])>=SELECTEDVALUE('Work Limit'[Work Limit]),1,0)