Enhance Power BI Desktop with INFO.MEASURES Function for Measure Descriptions as Tooltips

Introduce the INFO.MEASURES DAX function as part of creating tables in Power BI desktop and not only in the DAX Query editor view. This function would allow users to retrieve detailed information about measures directly within the report.

How It Would Work: When creating tables or visualizations, developer can add a tooltip expression that references the INFO.MEASURES table of the measures used to render a visualisation. The tooltip would dynamically display measure details (such as name, description, and expression) when users hover over a measure in the report.

Benefits: Improved Usability: Users can quickly understand what each measure represents without leaving the report.

Reduced Documentation Burden: Instead of maintaining external documentation, measure descriptions are readily available.

Enhanced Collaboration: Teams can collaborate more effectively by sharing insights about measures directly within the report.

Example Usage:Imagine you have a sales report with measures like “Total Sales,” “Average Order Value,” and “Conversion Rate.”

By adding tooltips with INFO.MEASURES, users can hover over these measures to see their purpose, calculation logic, and any relevant notes.

Community Impact:Empowering users with measure descriptions enhances their ability to interpret data and make informed decisions.

It fosters a more intuitive and user-friendly experience within Power BI reports.