Expression assistance

[tintin007]

Hi all,

I have a filter table to look up values from another table to produce a chart.

Currently works fine as it is but would like it to work slightly differently.

I currently have this expression which allows look up one item from each column in the filter table.

and(
any(Filter[Type])=[TYPE],
any(Filter[Sub]) =[SUB],         
any(Filter[User])=[USER],
any(Filter[Status])=[STATUS])

I cant figure out the best way to allow the formula to

  A) show all in the [sub] data if none are selected

B) allow multiple values in the Sub and user columns from an enum list from the a Data table I have the [sub] column set to look up as a valid if formula,

I have tried to use Or in place of any but cant get it to work. I think my thought process is wrong.

Suggestions to help guide me in the right direction would be appreciated,

Cheers

[Joseph_Seddik · Accepted solution]

---

---

@tintin007 wrote:

  A) show all in the [sub] data if none are selected

B) allow multiple values in the Sub and user columns from an enum list from the a Data table I have the [sub] column set to look up as a valid if formula,

---

IF( ISBLANK([SUB]), true, IN([SUB], ANY(Filter[Sub])) )

[tintin007]

HI Joseph, 

That works a whole lot better, I can see the logic in that now.

Many Thanks