Find unused measures in Power BI report

[Anonymous]

During development my Power BI reports end up with many measures that end up not being used in the final report (not by other measures not by any filters nor in any visuals). It would be very useful to be able to identify these measures and delete them. Does anyone know a way to do this easily?

[latimeria]

Hi @Anonymous ,

try with this: Power BI Cleaner Gen2 is here – The BIccountant

Explantion on how to use it: How to find, remove and hide unused Measures and Columns in Power BI - YouTube

[Anonymous]

@latimeria , thanks for the suggestion. Unfortunately Power BI Cleaner Gen2 (I used the PBIT) does not work on my report. It gives these error messages:

The PBIT also has some very strange behaviour. When it is first opened, it sits there with three spinning icons waiting for 2 minutes. I had not even entered the name of the report or any information yet, so God knows what this tool was doing for two minutes.

[daXtreme]

@Anonymous 

Simply put, there isn't such a way. You can (in Tabular Editor) identify (with a little bit of C# script code) measures that are not referenced anywhere else... but this will also return measures that are used in visuals. If you want to definitely know if there is such a way, you should ask this question to either Marco Russo/Alberto Ferrari or Daniel Otykier (the creator of Tabular Editor, he's got a GitHub account so you can find him there).