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

แชร์
ฝัง
  • เผยแพร่เมื่อ 8 ม.ค. 2025

ความคิดเห็น • 17

  • @MeasureKiller
    @MeasureKiller 6 หลายเดือนก่อน +5

    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.

    • @SolutionsAbroad
      @SolutionsAbroad  6 หลายเดือนก่อน +1

      Aha, I knew I was doing something wrong, thank you for clarifying! I've pinned this comment for everyone else!

  • @ax78360
    @ax78360 6 หลายเดือนก่อน +7

    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 ?

    • @MeasureKiller
      @MeasureKiller 6 หลายเดือนก่อน

      no of course not, it checks everything (model, visuals, conditional formatting, filters, even Power Query)

  • @JD_JR
    @JD_JR 6 หลายเดือนก่อน

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

  • @applesoranges559
    @applesoranges559 6 หลายเดือนก่อน

    🌟 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 🇮🇳 💯 ..

  • @klausjurgenfolz4323
    @klausjurgenfolz4323 6 หลายเดือนก่อน +2

    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.

  • @muhammadsabirhussain1503
    @muhammadsabirhussain1503 6 หลายเดือนก่อน

    Thank you.

  • @1yyymmmddd
    @1yyymmmddd 5 หลายเดือนก่อน

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

    • @MeasureKiller
      @MeasureKiller 5 หลายเดือนก่อน

      Yes we have an early build of a function to recognize duplicate DAX expressions. It is quite basic now but will get better over time.

  • @sanumpzha
    @sanumpzha 6 หลายเดือนก่อน

    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.

    • @MeasureKiller
      @MeasureKiller 5 หลายเดือนก่อน

      Measure Killer will show the title if you set one. Otherwise it will just say the type of chart.

  • @nikakalichava8012
    @nikakalichava8012 4 หลายเดือนก่อน

    I tried the measure killer. In my test file i had 6 measures and 6 columns. It said that i have 105 unused measures out of 345. This is a really great tool but needs a little fixing. :)

  • @martinltmr8590
    @martinltmr8590 5 หลายเดือนก่อน

    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

    • @MeasureKiller
      @MeasureKiller 5 หลายเดือนก่อน

      Maybe you do not have the latest version?!

  • @pankajsharmadelhi93
    @pankajsharmadelhi93 5 หลายเดือนก่อน

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

    • @MeasureKiller
      @MeasureKiller 4 หลายเดือนก่อน

      You can use the free version but this tool has not been built by Microsoft -> you can download it from measurekiller.com or the Microsoft Store