I have four different user filters in a dashboard detail view which let the users filter the data in the table view interactively. One filter is for ‘many days since last contact’, one filter for ‘client’, another for ‘stage’, e.t.c. I have a slice for the data through which my filters get applied using row filter conditions like
OR(OR(OR(ANY(Filter[Client])=[Client],ANY(Filter[Stage])=[Stage]),ANY(Filter[Communication Cycle])=[Communication Cycle]),ANY(Filter[Days Since Last Communication])<=[Days Since Last Communication])
All of the filters work independently but is there any way of allowing them all to be used in conjunction? I could go ahead and write out every combination possible but, before I do, does anyone know if there is a smarter/more efficient expression for this?