View DAX Expression in Direct Query Semantic Model(Read Only)

[ce138867]

Hi All,

Does anyone know of a way to find the underlying DAX expression for a measure if you only have read only access to a semantic model via direct query?

I'd like to use the same measures but use different values in the expression. Instead of trying to guess what's in the measure, it would be nice to see the expression even if it's read only. 

Thanks in advance

[lbendlin]

Have you asked the developer?

Connect to the semantic model with DAX Studio, go to Query Builder, then right click on the measure

Define and Expand

[ce138867]

I have not asked the developer. I am trying not to ask him about every new measure I want to use in my report with modified expressions. 

I did try your steps in DAX Studio but it only tells me that it's an external measure, with the name of the measure, data type and that it's a direct query. 

[lbendlin]

Then go ask the developer. Ask them to run EVALUATE INFO.MEASURES()

[ce138867]

The owner just gave me his entire report so I could look at the measures myself instead of running anything in Dax Studio. 

We should have the ability to see the measure expression when viewing a semantic model as read only.  We aren't updating the model, so why not provide this as part of default functionality within semantic model sharing. We shouldn't have to go to the developer to find this information if they've shared the model, even as read only.

Regardless, thank you for providing helpful information using this function in Dax Studio.