NONVISUAL DAX Function (Table manipulation)
Mark the filter as NonVisual.
Syntax
Parameter | Attributes | Description |
---|---|---|
Expression |
Filter expression. |
Return values
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: Dec 4, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber
Microsoft documentation: https://docs.microsoft.com/en-us/dax/nonvisual-function-dax