Database Reference
In-Depth Information
Each of the columns returned by this query represents a column used in either
the
KeyColumns
, the
NameColumn
, the
ValueColumn
, or a member property of an
attribute on the dimension. However, if you only wish to return some of the columns
and not all of them, you will need to remember that if you select one column, you
will also need to select all of the columns built from the
KeyColumns
property from
the same attribute for the query to run.
So, for example, trying to run the following DAX query will result in an error
because only one of the columns that represent the Fiscal Year hierarchy on the
Date
dimension is included:
EVALUATE SUMMARIZE('DATE', 'DATE'[Fiscal Year])
However, the following query will run successfully because it includes the column
'Date'[Fiscal Year.Key0]
:
EVALUATE
SUMMARIZE('DATE',
'DATE'[Fiscal Year.Key0],
'DATE'[Fiscal Year])
Here are the results of this query; all of the distinct key and name values used in the
Fiscal Year
attribute of the
Date
dimension:
