DETAILROWS DAX Function (Table manipulation) Context Transition
Returns the table data corresponding to the DetailRows expression defined on the specified Measure. If a DetailRows expression is not defined then the entire table to which the Measure belongs is returned.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Measure |
A Measure reference whose DetailRows expression is to be evaluated. |
Return values
Remarks
IMPORTANT : DETAILROWS should perform a context transition, but in SSAS 2017 it does not do that. The behavior by design is to perform a context transition, and this should be fixed in upcoming hotfix or service packs. As a workaround, if called in a row context, it should be wrapped in a CALCULATETABLE statement. Do not use in a row context if the intended behavior should not execute the context transition – assign the result of DETAILROWS in a variable before the iterator in that case.
Related articles
Learn more about DETAILROWS in the following articles:
-
Controlling drillthrough using Detail Rows Expressions in DAX
The Detail Rows Expression in a Tabular model provides the user with control over the drillthrough results obtained by showing details of a measure. This article describes typical DAX expressions you can use in this property. » Read more
Last update: Jul 8, 2020 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo