Allow measure-like table expressions in DAX

A calculated column is a scalar value that is computed in row context at model refresh time, and referenceable anywhere a normal field could be. A calculated table is a table value that is computed at model refresh time, and referenceable anywhere a normal table would be.

A measure is a named scalar valued expression that is evaluated in a filter context in a report.

I propose a named table-valued expression that is evaluated in filter context in a report, usable anywhere a table expression might otherwise be referenced. These could be used to allow FILTER () expressions to be reused across multiple measures taking advantage of CALCULATE () . This is especially useful for custom time intelligence, but there are many use cases.

As an additional use case, these might be able to form the basis of customizable drill-to-detail actions in the future. A link / action button could be tied to a named table-valued expression, which might then be displayed in a table visualization. Indeed, we might be able to use one of these named table-valued expressions in any table visualization, allowing trivial implementation of TOP N functionality for a table, and custom rollups to be easily implemented. These table-valued expressions would be expected to respond to brushing and linking, as measures do.