Make table immune to filter

[qluser01]

Hi all!

I have a loaded data like:

And I have a Table showing Color field.

When I make a filter - Color field in Table shows only Color for this Fruit, but I want to see all Color values in table, to make Table data immune to Fruit filter.

You can use attached file...

[OmarBenSalem · Accepted solution]

The only way is to add a measure (count{1}(1)) for example) to your table and then change the width of its column so It can't be visible anymore :

See the attached app

[vinieme12]

No need to add measure, try below

AGGR(only({1}  FieldName) , FieldName)

[OmarBenSalem]

Hi Vineeth,

I already tried that but that does not seem to do the job:

[vinieme12]

Hi Omar,

I misread the question, I thought we were working with a listbox.

You are correct we'll need to add an expression to the table