Need Help on DAX

Hi  aravinthets ,

Still unauthorized.Would you pls modify the link as public and reshare again?

Best Regards,
Kelly

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

Hi  aravinthets ,

Sorry for the late reply.

First create a calculated column to check whether that day is a working day.

Is workingday = IF(WEEKDAY('Sheet1'[Date],2)=7,0,1)

Then create a  measure as below:

Total leave =
DIVIDE (
    CALCULATE (
        SUM ( 'Sheet1'[total_hours] ),
        FILTER (
            ALL ( Sheet1 ),
            'Sheet1'[fullname] = MAX ( 'Sheet1'[fullname] )
                && 'Sheet1'[Is workingday] = 1
        )
    ),
    24
)

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

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