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.