Forum Discussion
How to identify unused measures
Hello,
Is there an easy or automatic way to identify unused mesures to optimize my report?
Thank you very much for any help
2 Replies
- SpartaBI
Community Champion
Hey,
1st of all unused measures don't affect the perormance of your report.
It's still a good practice to remove them just to not have "garbage" in your items when you look for something.
There are some tools that can do that, here is a refernce to them:
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=57307f15-e905-4c46-aaad-d888e1164179&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer#bmee629d90-5fa4-4328-9465-c24d5ce64cec - v-easonf-msft
Community Support
Hi, ouafaa
Currently, it is difficult to identify unused tables or fields in pbix files.
But you can get the corresponding list of measures in DAX Studio for retrieval.
Best Regards,
Community Support Team _ Eason