I’m filtering a slice based on user input within a dashboard as follows:
AND(ANY(Filter[Observation Type]) = [Observation Type], ANY(Filter[Description]) = [Description], ANY(Filter[Work Status]) = [Work Status], ANY(Filter[Start Date]) <= [Date and time], ANY(Filter[End Date]) >= [Date])
This expression works fine. But I want the user to have a choice whether or not to filter on “Description”. He would choose Yes or No to “Do you want to filter on Description?”.
If he chooses NO the expression would bring ALL Description types. I believe I would need to put together the above expression with another expression that doesn’t filter on Description, based on an IF statement.
Can this be done in one row filter expression and if so how?