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
Solved! Go to 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 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])) )
HI Joseph,
That works a whole lot better, I can see the logic in that now.
Many Thanks
User | Count |
---|---|
33 | |
30 | |
30 | |
19 | |
16 |