Forum Discussion

Catman's avatar
Catman
Frequent Visitor
1 year ago
Solved

Displaying DAX Report Local measures

We are trying to create Data Dictionary for our datasets and one of the attribute is to show the DAX measures in the Dataset as well as report specific measures. e.g. Calculate ( sumx())

 

We are using info.view.measures and it works by showing everything in the Dataset. However, the report local measures are not shown, when I want to apply to a specific report.

 

Do I use the same DAX function - info.view.measures or have to another one?

 

Thanks

Need Help
Tips and Tricks
  • FBergamaschi's avatar
    FBergamaschi
    1 year ago

    Report measures are not in the Dataset and the Dataset does not know about them, they are only included in the json of the report so you cannot use those functions to list them, these fucntions work at the semantic model (dataset) level.

     

    If this helped, please consider giving kudos and mark as a solution

    me in replies or I'll lose your thread

    consider voting this Power BI idea

    Francesco Bergamaschi

    MBA, M.Eng, M.Econ, Professor of BI

3 Replies

  • FBergamaschi's avatar
    FBergamaschi
    Super User
    1 year ago

    Report measures are not in the Dataset and the Dataset does not know about them, they are only included in the json of the report so you cannot use those functions to list them, these fucntions work at the semantic model (dataset) level.

     

    If this helped, please consider giving kudos and mark as a solution

    me in replies or I'll lose your thread

    consider voting this Power BI idea

    Francesco Bergamaschi

    MBA, M.Eng, M.Econ, Professor of BI

  • MasonMA's avatar
    MasonMA
    Super User
    1 year ago

    Catman 

     

    Hi, I normally manually document those local measures:), however you may try some external tools like Tabular Editor and see if those measures can be exported from the tool.

    Thanks 

  • v-venuppu's avatar
    v-venuppu
    Community Support
    1 year ago

    Hi Catman ,

    Thank you for reaching out to Microsoft Fabric Community.

    Thank you MasonMA FBergamaschi for the prompt response.

    I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

    Thank you.