NONVISUAL DAX Function (Table manipulation)
Mark the filter as NonVisual.
Syntax
NONVISUAL ( <Expression> )
| Parameter | Attributes | Description |
|---|---|---|
| Expression |
Filter expression. |
Return values
Table An entire table or a table with one or more columns.
A table of values.
Remarks
Marks a value filter in SUMMARIZECOLUMNS function as not affecting measure values, but only applying to group-by columns.
Examples
-- NONVISUAL marks a SUMMARIZECOLUMNS filter so that it does
-- not affect measures using ALLSELECTED as part of their
-- calculation.
-- It can be used to obtain non-visual totals at the query level.
DEFINE MEASURE Sales[Amount ALLSELECTED] =
CALCULATE ( [Sales Amount], ALLSELECTED ( 'Date'[Calendar Year] ) )
EVALUATE
SUMMARIZECOLUMNS (
'Date'[Calendar Year],
TREATAS ( { "CY 2008", "CY 2009" }, 'Date'[Calendar Year] ),
"Amount", [Sales Amount],
"Amount ALLSELECTED", [Amount ALLSELECTED]
)
EVALUATE
SUMMARIZECOLUMNS (
'Date'[Calendar Year],
NONVISUAL ( TREATAS ( { "CY 2008", "CY 2009" }, 'Date'[Calendar Year] ) ),
"Amount", [Sales Amount],
"Amount ALLSELECTED", [Amount ALLSELECTED]
)
| Calendar Year | Amount | Amount ALLSELECTED |
|---|---|---|
| 2008-01-01 | 9,927,582.99 | 19,281,397.86 |
| 2009-01-01 | 9,353,814.87 | 19,281,397.86 |
| Calendar Year | Amount | Amount ALLSELECTED |
|---|---|---|
| 2008-01-01 | 9,927,582.99 | 30,591,343.98 |
| 2009-01-01 | 9,353,814.87 | 30,591,343.98 |
Related functions
Other related functions are:
Last update: Oct 15, 2021 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/nonvisual-function-dax
2018-2021 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies