wallingfordce's avatar
wallingfordce
Data Pipeline
01-21-2026
Status:
New Idea

Make Filtered Measures plugin work like filtered measures when same field on rows and filter

In this scenario we have...

  • the Filtered Measure plug enabled 
  • a dashboard with Brand as a filter, set to include only "ABC"
  • a pivot widget with Brand on Rows set to filter as Highlight
  • values for 
    • Total Quantity (working as expected)
    • Total Quantity for Brand = "ABC" (working as expected)
    • Total Quantity for @Brand (working as Sisense expects, but not how we'd expect)

The "ABC" row is highlighted as being selected in the dashboard filter. As expected per the Active Filters in Widgets Calculation Hierarchy, the [Total Quantity for Brand = "ABC"] value displays the Total Quantity for the Brand "ABC" row on every row, overriding the row-level Brand grouping/filter for every row. Meanwhile, the [Total Quantity for @Brand], which I would expect to filter on "ABC" as per the dashboard filter, fails to override the row level grouping.

I would like for the [@Brand] filter to work in exactly the same way as the [Brand = ABC] filter. With that, our clients go easily do cross-over analysis via multi-pass aggregation:

For the customers that purchased the Brand on rows, how many also purchased the "ABC" brand. If ECommerce had a Customer ID in it that might look like:

SUM ( [Customer ID] ,  --limited to customers that purchased the Brand of the row
 IF ( ( [Total Quantity] , [@Brand] ) > 0 , 1 , 0 
--count the customers that purchased the selected dashboard filter Brand, "ABC"
)

However, per Sisense Support...

Filters defined inside a measure (using the Filtered Measure add-on or formula-level filters) are evaluated earlier in the calculation hierarchy and are isolated from the widget row context. This is why your formula-based approach works and produces consistent baseline and overlap results, while relying on the dashboard filter does not.

When the same dimension (Brand) is used both on widget rows and as a dashboard filter, the dashboard filter is evaluated in the context of each row. Because of this shared dimensional context, the dashboard filter cannot act as a fixed reference baseline (for example, “ABC”) across all rows.

No CommentsBe the first to comment