How to show values only for visible date

[Anonymous]

I have created following measure that showing only Employee_Capacity in column 5:

Employee_Capacity =

VAR WeekdayTable = FILTER ( DIM_DATE, DIM_DATE[T_Day_Of_Week_No] = 5 )

RETURN

    SUMX (

        WeekdayTable,

        [Employee Capacity]

    )

But Like to show Employee_Capacity for Roster_hours only visible for Start_Of_Week_Date as follows:

How can I accomplish this task? I need help please.

Cheers

Rahil

[Anonymous]

Hi Ashish,
Thanks for your prompt reply. I haven't test it yet. I will let you know if it works.

cheers

[Ashish_Mathur]

Hi,

Does this work

Employee_Capacity =

VAR WeekdayTable = FILTER ( DIM_DATE, DIM_DATE[T_Day_Of_Week_No] = 5 )

RETURN

    IF(ISBLANK([Working hours]),BLANK(),SUMX (

        WeekdayTable,

        [Employee Capacity]

    ))

I have assumed that Working hours is a measure.