Forum Discussion
Measure Usability
Hi,
I am working to build an comlex Report and ended up in creating a large number of measures.
Now some of them may not be used in the report.
1) Is there any way to find out unused Measures in the Report?
Install the Dax studio software and check the usage of all the columns including measure and columns settings in view metric option in advanced settings.
if the measure are not in use, check in power bi and delete that measure which is not used as per business purpose.
Regards,
Rajendra
- Hi Anonymous ,You can try to use DAX studio.Although there will be problems between xvelocity and the query engine. However, it removes unused measure.https://www.sqlbi.com/articles/capturing-power-bi-queries-using-dax-studio/You can also try the methods mentioned in this thread:https://community.powerbi.com/t5/Desktop/Best-way-to-delete-multiple-measures-in-tables/td-p/415716Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Install the Dax studio software and check the usage of all the columns including measure and columns settings in view metric option in advanced settings.
if the measure are not in use, check in power bi and delete that measure which is not used as per business purpose.
Regards,
Rajendra
Refer
https://community.powerbi.com/t5/Desktop/Determine-which-measures-are-used-in-a-report/td-p/526784
https://radacad.com/power-bi-cleanup-tool-time-saving-with-power-bi-helper
https://community.powerbi.com/t5/Desktop/How-to-find-where-a-column-is-used/td-p/227623
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin- Hi Anonymous ,You can try to use DAX studio.Although there will be problems between xvelocity and the query engine. However, it removes unused measure.https://www.sqlbi.com/articles/capturing-power-bi-queries-using-dax-studio/You can also try the methods mentioned in this thread:https://community.powerbi.com/t5/Desktop/Best-way-to-delete-multiple-measures-in-tables/td-p/415716Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
