Measure Usability

[Anonymous]

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?

[rajendraongole1 · Accepted solution]

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.

https://daxstudio.org/

Regards,

Rajendra

[V-lianl-msft · Accepted solution]

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/415716 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Refer

https://ssbi-blog.de/blog/technical-topics-english/how-to-identify-measures-not-used-in-your-pbix-fi...

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

[rajendraongole1 · Accepted solution]

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.

https://daxstudio.org/

Regards,

Rajendra