March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi all,
I'm trying to create a table containing description of all measures in my model to generate a documentation table insiede the report.
Solved! Go to Solution.
Hi @campagna -If feasible, consider using a direct query to your data source to retrieve measure information. This might help bypass some of the limitations present in the Power BI model.As a temporary solution, manually create a documentation table by documenting the measures and their descriptions, especially for critical measures.
You could also use DAX Studio to extract the measure definitions.
The INFO.VIEW.MEASURES() function has known limitations in certain scenarios, especially when there are complex hierarchies or an extensive number of measures.
use dax studio and check the below measure:
EVALUATE
ADDCOLUMNS(
MEASURES,
"Description", [YourDescriptionMeasure] // Replace with an appropriate measure for description if available
)
While the error you’re encountering may relate to measure organization, utilizing workarounds and ensuring your environment is up to date may help mitigate the problem.
Proud to be a Super User! | |
Hi @campagna -If feasible, consider using a direct query to your data source to retrieve measure information. This might help bypass some of the limitations present in the Power BI model.As a temporary solution, manually create a documentation table by documenting the measures and their descriptions, especially for critical measures.
You could also use DAX Studio to extract the measure definitions.
The INFO.VIEW.MEASURES() function has known limitations in certain scenarios, especially when there are complex hierarchies or an extensive number of measures.
use dax studio and check the below measure:
EVALUATE
ADDCOLUMNS(
MEASURES,
"Description", [YourDescriptionMeasure] // Replace with an appropriate measure for description if available
)
While the error you’re encountering may relate to measure organization, utilizing workarounds and ensuring your environment is up to date may help mitigate the problem.
Proud to be a Super User! | |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
134 | |
91 | |
89 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
72 | |
68 |