Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago
Solved

OVERTIME

Good morning I'm doing internships at a mechanical services company, and I'm using Power BI to analyze the hours worked per mecáncio, and the overtime they do. To calculate this last I have crea...
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  Syndicate_Admin ,

    I created a simple sample as below:

    Then create a measure as below:

    Measure =
IF (
    ISINSCOPE ( 'Table'[Subcategory] ),
    'Table'[EX],
    SUMX ( VALUES ( 'Table'[Subcategory] ), 'Table'[EX] )
)

    And you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

     

lbendlin's avatar
lbendlin
Super User
5 years ago

Not very clear what your actual question is. Is the slicer column connected to the rest of the data model?

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    5 years ago

    Yes, it is connected. And the questions are how can I get the sum of overtime per worker? with the clearest possible design and what should I do to get only the work parts corresponding to the date range to appear?

    Thank you very much for your interest,