Filter by dimension values

A property lookup can select one dimension value, several values, or every value of a dimension.

Select one value

Revenue[Department: "Sales"]

This changes Department to Sales while other dimensions continue to follow the current segment.

Select several values

Use a set:

Revenue[Department: {"Engineering", "Product", "Design"}]

A multi-value metric lookup is summed when no aggregation function is written. Add the intended function when another behavior is clearer:

average(Revenue[Department: {"Engineering", "Product", "Design"}])

Exclude values

Revenue[Department: NOT {"Engineering"}]

Select every value

Revenue[Department: ANY]

This is useful for totals, averages, and percent-of-total calculations.

Filter with an expression

Use where when membership depends on another value:

Revenue[Department: where Headcount > 0]

Inside a where filter, a plain property refers to each candidate value. Use thisSegment when you need to compare a candidate with the current cell:

Revenue[Department: where Headcount > thisSegment.Headcount]

Combine dimensions

Revenue[Region: "West", Department: "Sales"]

Keep filters as narrow as the business rule requires. If the same rule applies to the current segment, prefer a plain property reference.

​Select one value

​Select several values

​Exclude values

​Select every value

​Filter with an expression

​Combine dimensions