I have a formula that works as long as the State column in a table(where the filter is being applied) has a single value. I have a use case where I do not wish to apply this filter if the State has no value i.e. a blank State should return all rows in the table without applying the filter. A second use case is if I have State with say 2 values. How would the expression be written then? Thanks.
[STATE] = ANY(
SELECT(Member[State],
[Email] = USEREMAIL()
)
)
LinkedIn
Twitter
