Forum Discussion

oolamide85's avatar
oolamide85
Frequent Visitor
7 years ago
Solved

Visual Level Filter

I have visualisation show workers by weekly hours, but I want my visual to display on worker with more than 72Hrs per week.   Please see attached and am getting my sum of hours from column worked_H...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi oolamide85

 

You may try to create a measure like below to get the visual as requested.

Measure  =
VAR workhours =
    CALCULATE ( SUM ( Table4[worked hours] ) )
RETURN
    IF ( workhours >= 72, workhours )

Regards,

Cherie

oolamide85's avatar
oolamide85
Frequent Visitor
7 years ago

The Column workhours are daily worked hours and I have the sum of worked hours in week in report view which is fine, but I want the report to show only worked who have worked more than 72hrs . 

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    Hi oolamide85

     

    Here is the sample file. If it is not your case, please share your data sample file. You can upload it to OneDrive or Dropbox and post the link here.

     

    Regards,

    Cherie

    • oolamide85's avatar
      oolamide85
      Frequent Visitor
      7 years ago

      unable to download the file.

       

      Thanks.