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!

     

v-kelly-msft's avatar
v-kelly-msft
Community Support
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!

 

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago

Thanks a lot!

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    Hi  Syndicate_Admin ,

     

    Glad to help.

    If your issue is solved,could you pls mark the reply as answered to let more people find it?

     

    Best Regards,
    Kelly

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