Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to show values only for visible date

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

Need Help

2 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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

    cheers