Forum Discussion
how to get measures in use
Hi Community!
I have a big semantic model with many visual and measures too, so I'm trying to find a view to get information about visual and measures in use, the requirement is remove unnecessary measures.
I'm don't find any table with such data, INFO.MEASURES, INFO.CALCDEPENDENCY, etc.
Using dax studio in DMV report, Maybe... I don't know ..
Is there anyway to get such data?
Hi Peter_23
Thank you for your question and for exploring the options through DMVs and DAX Studio.
Currently, Microsoft Fabric and Power BI do not natively provide a direct mapping between visuals and their specific measures. Although DMVs like DISCOVER_CALC_DEPENDENCY and INFO.MEASURES can help explore dependency chains between measures, they do not show usage within report visuals.
To identify and potentially remove unused measures, the Performance Analyzer pane in Power BI Desktop can trace which measures are triggered during visual rendering. This method, though manual, can be effective for smaller models or targeted checks.
We also recommend submitting your feedback to the Power BI Ideas platform if you would like to see this feature (measure usage tracking) supported in future releases. Feedback submitted through these channels is frequently reviewed by the product teams and can contribute to meaningful improvements.
Fabric Ideas - Microsoft Fabric Community
And also go through the similar thread links provided by NandanHegde for reference
If my response was helpful, consider clicking "Accept as Solution" and give us "Kudos" so that other community members can find it easily. Let me know if you need any more assistance!
Thank you.
3 Replies
Hi Peter_23
Thank you for your question and for exploring the options through DMVs and DAX Studio.
Currently, Microsoft Fabric and Power BI do not natively provide a direct mapping between visuals and their specific measures. Although DMVs like DISCOVER_CALC_DEPENDENCY and INFO.MEASURES can help explore dependency chains between measures, they do not show usage within report visuals.
To identify and potentially remove unused measures, the Performance Analyzer pane in Power BI Desktop can trace which measures are triggered during visual rendering. This method, though manual, can be effective for smaller models or targeted checks.
We also recommend submitting your feedback to the Power BI Ideas platform if you would like to see this feature (measure usage tracking) supported in future releases. Feedback submitted through these channels is frequently reviewed by the product teams and can contribute to meaningful improvements.
Fabric Ideas - Microsoft Fabric Community
And also go through the similar thread links provided by NandanHegde for reference
If my response was helpful, consider clicking "Accept as Solution" and give us "Kudos" so that other community members can find it easily. Let me know if you need any more assistance!
Thank you.
Thanks Anonymous I finded measure killer, this tool could be get measure in use/ not use.
