Posts Tagged ‘Cleaner’

Power BI Cleaner now fully covers Calculation Groups

You can now download a new version of my Power BI Cleaner tool that finally covers usage of DAX expressions in Calculation Groups as well. For an introduction into this tool and further limitations, please check out this post. There is also a nice article from Matt Allington covering some additional aspects.

Calculation Group coverage

Until today, you would only see which calculation group has been used in your report, but not which DAX expression (measure or column) has been used to create it. But with the new version (V11) you will not run into the risk anymore to delete a measure for example, that has been used to create a calculation group. Their usage will be covered under the category “measures and columns”.

In the file attached, you can see that the column “Net Price” has been used in “MeasuresAndColumns”:

When you drill through “Where Used Indirect” you can identify the usage in the calculation group:

You can download the file (V11) here:  PowerBICleanerV11_upload.zip   (After download, rename the xxx.zip to xxx.pbix to open the file in PBI Desktop)

Enjoy & stay queryious 😉

Tidy up Power BI models with the Power BI Cleaner tool

Edit 23th June 2020: Updated version (see download link at the end of the article) to reflect changes with the vpax fileformat in DAX Studio versions V11.0 upwards.

The VertiPaq-Analyzer tool is one of the great community tools that I really cannot live without. It gives me a great overview of all elements in my model and identifies potential performance problems by showing the storage requirements of each column. So when seeing expensive columns, the first question that arises is: “Do I really need this column or could I delete it?”. Luckily, this can now be answered with my new Power BI Cleaner tool. This tool shows the usage of all columns (and measures) within the tables of the VertiPaq Analyzer.

Power BI Cleaner shows unused columns in the VertiPaq-tables

Power BI Cleaner tool

So whenever there is no entry in the column “Where Used” you can go ahead and eliminate the column (or measure) from the model. Well – with two exception actually: Fields used in the definition of incremental load policies are currently not identified as well as used fields in calculation groups. So make sure to consider this before running wild 😉 Read more