REMOVE UNUSED MEASURES and COLUMNS using MEASURE KILLER // Beginners Guide to Power BI

In this video were going to look at the Measure Killer tool by Brunner BI to help you identify and delete unused columns and measures from your model.

🕓 TIMESTAMPS
0:00 - Intro
01:08 - Download
02:37 - Basics
05:57 - Removing Calculations
07:09 - Removing Columns
08:51 - Conditional Formatting Issue

-

📣 Get Demo Files HERE

🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required.

📰 Sign up to our FREE Weekly Newsletter for Power BI news, community updates and more

🛒 Power BI TEMPLATES and more at our digital shop

❤ Other ways to SUPPORT us

📧 GET IN TOUCH

🤝 SOLUTIONS ABROAD
Hi Power BI fans, my name is Fernan. In 2018 I founded Solutions Abroad to help fellow data enthusiasts learn Microsoft’s tool, Power BI. I’m currently based in London with over 8 years of experience working with data and business intelligence. In this channel I provide educational videos about Power BI including tips and tricks, step by step tutorials, news, and all of it for FREE. I also provide some paid content such as courses, templates as well as consultancy services.
If you like what we’re doing here and would like to support, consider purchasing something or donating through our Patreon, every little penny helps us keep the channel going.

🙏 THANK YOU
Thank you so much for checking out my channel and my videos. You, the community, have been instrumental in growing the channel to where it is now. Hope to see you again on my next video!

#PowerBI #DataAnalytics #BusinessIntelligence

[MeasureKiller]

Hey Fernan, it will also detect conditional formatting. You just need to save your report every time you make a change to any visual, conditional formatting etc.

[ax]

Hi thanks for making me discover this tool. One question: if a measure is unused in a visual but is used to calculate an other measure, would this tool flag it as unused ?

[klausjurgenfolz]

Hi Fernan, thanks for the video. The tool detects conditional formatting, the issue is that you have to save the report file to apply the changes to the layout (definition) and then run again to see the changes.

[applesoranges]

🌟 YOU ARE THE VERY BEST FERNAN 💯 ... A Really Long time fan of ur work n wanted to inform u that ur content REALLY helps .. So much ❤️ n Blessings from Bengaluru 🇮🇳 💯 ..

[JD_JR]

Thanks for sharing! Super useful for cutting out clutter and unused queries.

[sanumpzha]

Intersting one as usual 👍. For the Chart name, why dont Power BI use the chart title as a name for easy underatading instead putting card visual, bar chart etc.

[yyymmmddd]

Cool. Does it also recognize duplicate measures? Like
my1=sum(Sales(Amount)
my2=sum(Sales(Amount)

?

[pankajsharmadelhi]

Hey Fernan could you please share the documents which says this is a free MSTool

[martinltmr]

My menu is lacking many views, I only get RESULTS, TABLES, KILL MEASURES And COLUMNS, KILL COLUMMS? I´m connected to a PBI semantic model