Display Name formula

[PhilW]

Morning All,

I’ve got my first App working well.

The last thing I want is to display a total under the view icon - of what is currently shown

I managed to get this to work using Count(TableName[ColumnName])

But I want it to change to reflect searched results.

I won’t try and use my data - but as an example if my table was Calendar and column Months the above will show 12 under the icon.

If I use the search icon (top right on the app) and enter January the result would change to show January but the number 12 still showing under the icon.

But it needs to be 1

Hope that explains it!

Any help would be appreciated.

Spent a long time trying to figue this out but not really gettiing anywhere

Thanks

Phil

[GreenFlux]

PhilW:

I managed to get this to work using Count(TableName[ColumnName])

But I want it to change to reflect searched results.

There’s no way to interact with the built-in search that would give you the total matching record count.

---

But you can build your own search, and count the matching records with a virtual column.

Search multiple columns with different criteria Tips & Tricks 💡

The built in search is very easy to use, but it only allows a single search term across all (searchable) columns. [36%20AM] A multi-term search can be built by constructing a Virtual Column of type List with elements of type Reference. The formula should return a list of keys from the table you want to search, and should update the list based on your search terms. FILTER("Order", AND( OR( ISBLANK([_THISROW].[Status]) , IN([Status] ,[_THISROW].[Status]) ), OR( ISBLANK([_THISR…

You will have to add another table to search from, and add a virtual column (Ref) to the table you want to search.