ADDMISSINGITEMS - Daxplained

ADDMISSINGITEMS is a DAX function that adds rows with empty measure values back into a table.

Syntax

ADDMISSINGITEMS(
   [ ShowAll_ColumnName, ... ],
   Table,
   [ GroupBy_ColumnName, ... ],
   [ FilterTable, ... ]
)

Argument	Properties	Description
ShowAll_ColumnName	Optional, Repeatable	ShowAll columns.
Table		A SummarizeColumns table.
GroupBy_ColumnName	Optional, Repeatable	A column to group by or a call to ROLLUPGROUP function and ROLLUPADDISSUBTOTAL function to specify a list of columns to group by with subtotals.
FilterTable	Optional, Repeatable	An expression that defines the table from which rows are to be returned.

Return Values

A table with one or more columns.

Remarks

This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

With SUMMARIZECOLUMNS

A table returned by SUMMARIZECOLUMNS will include only rows with values. By wrapping a SUMMARIZECOLUMNS expression within an ADDMISSINGITEMS expression, rows containing no values are also returned.

Empty

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/addmissingitems-function-dax