Forum Discussion

ce138867's avatar
ce138867
Icon for Resolver II rankResolver II
1 year ago

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

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

4 Replies

  • 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's avatar
      ce138867
      Icon for Resolver II rankResolver II

      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's avatar
        lbendlin
        Icon for Super User rankSuper User

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