ADDMISSINGITEMS DAX Function (Table manipulation)

Dodaj ponownie wiersze z pustymi wartościami miary.

Syntax

ADDMISSINGITEMS ( [<ShowAll_ColumnName> [, <ShowAll_ColumnName> [, … ] ] ], <Tabela> [, <GroupBy_ColumnName> [, [<FilterTable>] [, <GroupBy_ColumnName> [, [<FilterTable>] [, … ] ] ] ] ] ] )
Parameter Attributes Description
ShowAll_ColumnName Optional
Repeatable

Kolumny ShowAll.

Tabela

Tabela SummarizeColumns.

GroupBy_ColumnName Optional
Repeatable

Kolumna, według której zostanie wykonane grupowanie lub dla której zostaną wywołane funkcje ROLLUP i ISSUBTOTALCOLUMNS w celu określenia listy kolumn, które zostaną zgrupowane za pomocą sum częściowych.

FilterTable Optional
Repeatable

Wyrażenie definiujące tabelę, z której będą zwracane wiersze.

Return values

Table An entire table or a table with one or more columns.

Examples

Consider the result of the following query with SUMMARIZECOLUMNS:

EVALUATE
SUMMARIZECOLUMNS (
    'Date'[Calendar Year],
    "Quantity", SUM ( Sales[Quantity] )
)
Calendar Year Quantity
CY 2007 5,551,636
CY 2008 5,029,924
CY 2009 6,956,456

The Date table includes years ranging from 2005 to 2011, but SUMMARIZECOLUMNS only shows years that have a result in Quantity. You can include years without any corresponding quantity by wrapping the expression in ADDMISSINGITEMS, specifying the columns for which you want to include “empty” members. The next query adds the years without data to the result of SUMMARIZECOLUMNS:

EVALUATE
ADDMISSINGITEMS (
    'Date'[Calendar Year],
    SUMMARIZECOLUMNS (
        'Date'[Calendar Year],
        "Quantity", SUM ( Sales[Quantity] )
    ),
    'Date'[Calendar Year]
)
Calendar Year Quantity
CY 2007 5,551,636
CY 2008 5,029,924
CY 2009 6,956,456
CY 2005
CY 2006
CY 2010
CY 2011

Last update: Dec 14, 2019   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

MSDN documentation: https://docs.microsoft.com/en-us/dax/addmissingitems-function-dax

DAX Conventions
Context Transition

This function performs a Context Transition if called in a Row Context. Click to read more.

Row Context

This expression is executed in a Row Context. Click to read more.

Iterator

Not recommended

The use of this function is not recommended. See Remarks and Related functions for alternatives.

Not recommended

The use of this parameter is not recommended.

Deprecated

This function is deprecated. Jump to the Alternatives section to see the function to use.

Deprecated

This parameter is deprecated and its use is not recommended.

Contribute

Want to improve the content of ADDMISSINGITEMS? Did you find any issue?
Please, report it us! All submissions will be evaluated for possible updates of the content.


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.