Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Measure to affect Date Slicer

Hi BI Community,   I would like to ask wheather I select a date from dropdown filter it affects two other slicers. What I mean. My report is run every monday on excel and want to move it to PBI. ...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, Anonymous

    You need to create a measure rather than a calculated column.

    Visual filter(WorkerFlag) = 
IF (
    SELECTEDVALUE ( Workers[Start_date] ) < SELECTEDVALUE ( DatesTbl[Date] )
        && SELECTEDVALUE ( Workers[End_Date] ) >= SELECTEDVALUE ( DatesTbl[Date] ),
    1,
    0
)

    Then apply this new meaure to 'filters on this visual' of viusal filter pane.

    Count_ID = 
VAR tab =
    FILTER (
        Workers,
        Workers[Start_date] < SELECTEDVALUE ( DatesTbl[Date] )
            && Workers[End_Date] >= SELECTEDVALUE ( DatesTbl[Date] )
    )
RETURN
    CALCULATE ( DISTINCTCOUNT ( Workers[Calendar_ID] ), tab )

    Please check my sample file for more details.

     

    Best Regards,
    Community Support Team _ Eason

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous

You need to create a measure rather than a calculated column.

Visual filter(WorkerFlag) = 
IF (
    SELECTEDVALUE ( Workers[Start_date] ) < SELECTEDVALUE ( DatesTbl[Date] )
        && SELECTEDVALUE ( Workers[End_Date] ) >= SELECTEDVALUE ( DatesTbl[Date] ),
    1,
    0
)

Then apply this new meaure to 'filters on this visual' of viusal filter pane.

Count_ID = 
VAR tab =
    FILTER (
        Workers,
        Workers[Start_date] < SELECTEDVALUE ( DatesTbl[Date] )
            && Workers[End_Date] >= SELECTEDVALUE ( DatesTbl[Date] )
    )
RETURN
    CALCULATE ( DISTINCTCOUNT ( Workers[Calendar_ID] ), tab )

Please check my sample file for more details.

 

Best Regards,
Community Support Team _ Eason