Determine What Table a Measure is Defined On

[littlemojopuppy]

Hi -

I don't think this is possible, but I'll try anyway.  I have two calculation items that are almost identical...

 

Sales Category is a degenerate dimension on both tables (there is no dimension table for either field).  Was thinking that if I could determine what table a measure is defined on I could throw in an IF or SWITCH statement to use the appropriate filter.

Unfortunately, due to development standards, creating a calculated table for the dimension is not an option.

So is there a DAX function that returns what table a measure is defined on?

[littlemojopuppy]

Hola @lbendlin !

I could stick every measure in my model on the date table, or customer, or item or a free standing Report Measures table. Those measures could reference any field or other measure defined elsewhere in a model.  But measures have to be defined as part of a table somewhere.

I'll log into my work laptop to show this in a bit, but is there any way to reference what table a measure is actually defined on?

[littlemojopuppy]

Screen snip of saving a model to folder with TE3.  Table is Sales Invoice Lines, clearly measures defined on a table.  Base Average Cost defined on that table.

I want to know if there's a way to determine what table a given measure is defined on.

[lbendlin · Accepted solution]

Most likely the home table can be retrieved via a DMV query. Definitely not via DAX.

[littlemojopuppy]

I didn't think there was a DAX way of referencing the table a measure lives on.  Thank you for looking at it.

[lbendlin]

measures are defined on semantic models, not on tables.