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