Get filteredRowCount excluding a certain filter

[apolo-damasco]

Context

I’m trying to display, for each filter option, the number of rows that would be available after applying all other filters on the table. Using table.createCalculation(filterColumn).distinct() works for getting the distinct values, but there’s an issue:

When a user selects a value in a filter, the calculation also respects the current selection within that same filter. This leads to confusing results—for example, a user might see that the option "lorem" has a count of 0, not because other filters exclude it, but simply because they are already filtering by "ipsum" in the same filter.

Problem Description

I haven’t found an efficient way to compute these counts. Using table.createCalculation(column).distinct() includes the filter’s own selections, which results in misleading counts. Manually reconstructing the filter state while excluding a specific filter is possible but inefficient and error-prone.

Request

It would be very helpful to have a built-in helper method in the table class that returns filter option counts ignoring the current filter’s own selections, while still applying all other active filters. This would greatly simplify implementing intuitive filter UIs.

[vincjo]

I'm not sure I understand.
For me there are 2 possibilitites:

• static distinct values which are not updated by any filter

const distinct = table.createCalculation('field').distinct()

• dynamic, that rely on the table rows (after filters and search)

const distinct = $derived(table.createCalculation('field').distinct())

I think you can map filter counts before any filter is applied and store the values inside a satic const which never change