Forum Discussion

CBReflect's avatar
CBReflect
Regular Visitor
3 years ago

Slicer Options Based on Another Slicer

Hi, I have a tab for team member performance that has two slicers. One slicer is a vertical list date slicer with Year, Month and Week Beginning Date. The second slicer has a list of employees. ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi CBReflect ,

 

According to your statement, I think you are creating a measure. As far as I know, Power BI doesn't support us to use a column in measure directly, we need to use some aggregation functions like MAX()/MIN()/SUM() to get aggregation data in our measure. Or we will get error in our measure.

Active Staff at Filter Date =
SWITCH (
    TRUE (),
    MAX ( 'Aircall User Listing'[Start Date] ) > [End of Week Selected], "No",
    MAX ( 'Aircall User Listing'[Termination Date] ) < [Start of Week Selected], "No",
    MAX ( 'Aircall User Listing'[Start Date] ) < [Start of Week Selected]
        && MAX ( 'Aircall User Listing'[Termination Date] ) = "", "Yes",
    MAX ( 'Aircall User Listing'[Start Date] ) < [Start of Week Selected]
        && MAX ( 'Aircall User Listing'[Termination Date] ) > [Start of Week Selected], "Yes",
    MAX ( 'Aircall User Listing'[Start Date] ) < [End of Week Selected]
        && MAX ( 'Aircall User Listing'[Termination Date] ) = "", "Yes",
    MAX ( 'Aircall User Listing'[Start Date] ) < [End of Week Selected]
        && MAX ( 'Aircall User Listing'[Termination Date] ) > [End of Week Selected], "Yes",
    "-"
)

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.