topic Re: Determine What Table a Measure is Defined On in DAX Commands and Tips

Determine What Table a Measure is Defined On

littlemojopuppy — Mon, 12 Aug 2024 20:56:22 GMT

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?

Re: Determine What Table a Measure is Defined On

lbendlin — Mon, 12 Aug 2024 23:38:00 GMT

measures are defined on semantic models, not on tables.

Re: Determine What Table a Measure is Defined On

littlemojopuppy — Tue, 13 Aug 2024 01:57:26 GMT

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?

Re: Determine What Table a Measure is Defined On

lbendlin — Tue, 13 Aug 2024 02:06:16 GMT

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

Re: Determine What Table a Measure is Defined On

littlemojopuppy — Tue, 13 Aug 2024 02:08:16 GMT

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.

Re: Determine What Table a Measure is Defined On

littlemojopuppy — Tue, 13 Aug 2024 02:12:58 GMT

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