set_detail_rows
Define drillthrough detail rows for Power BI measures or tables by providing a DAX table expression. Set per-measure definitions or default rows.
Instructions
Define drillthrough detail rows - the DAX table returned when a user drills into a measure value (or the table's default). Set measure for a per-measure definition, or omit it to set the table's default detail rows. daxTableExpression is a DAX table expression, e.g. "SELECTCOLUMNS('Sales', ...)".
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | table (the measure's table, or the table whose default rows you're setting) | |
| measure | Yes | measure name for a per-measure definition; omit for the table default | |
| sessionId | Yes | ||
| daxTableExpression | Yes | DAX table expression returning the detail rows |