NONVISUAL

Applies to: Calculated column Calculated table Measure Visual calculation

Marks a value filter in a SUMMARIZECOLUMNS expression as non-visual. This function can only be used within a SUMMARIZECOLUMNS expression.

Syntax

NONVISUAL(<expression>)

Parameters

Term	Definition
expression	Any DAX expression that returns a single value (not a table).

Return value

A table of values.

Remarks

• Marks a value filter in SUMMARIZECOLUMNS as not affecting measure values, but only applying to group-by columns.

• This function can only be used within a SUMMARIZECOLUMNS expression. It's used as either a filterTable argument of the SUMMARIZECOLUMNS function or a groupLevelFilter argument of the ROLLUPADDISSUBTOTAL or ROLLUPISSUBTOTAL function.

Example

See SUMMARIZECOLUMNS.