Deep dive into measure filters in Power BI Desktop

Поделиться
HTML-код
  • Опубликовано: 11 дек 2024
  • НаукаНаука

Комментарии •

  • @sane7263
    @sane7263 3 года назад +2

    Enjoying DAX because of you! Thanks Alberto😀

  • @khurramshahzed4925
    @khurramshahzed4925 2 года назад +1

    I couldn't find the way, how I thanks to you for your devastating effort to teach. Allah bless you with health, prosperity and knowledge. Ameen. You are

  • @IoriYagamiKOF98
    @IoriYagamiKOF98 3 года назад +5

    instead of modify the base measure [Amt], coudln't you modifiy the [Ranking] measure Inside the RANKX by adding a zero to the CALCULATE ([Amt]...) +0 ?, so the base Measure [Amt] keeps returning blank for future reports?

    • @SQLBI
      @SQLBI  3 года назад +1

      It looks like a good option. The video is more about how to find the issue and debug it. The solution, then, really depends on the specific requirements. Thanks for bringing this to our attention!

  • @Amr-Ibrahim-AI
    @Amr-Ibrahim-AI 2 года назад +1

    Thanks Alberto for the detailed explanation!
    I enjoyed the thought process and learned A LOT from this valuable video

  • @ejazahmedev
    @ejazahmedev 3 года назад +2

    Thank you for democratizing such advanced knowledge. God Bless!

  • @fr1sket363
    @fr1sket363 3 года назад

    Yes i have seen this very example in a report i built, the difference is now i understand why 😆. Thanks so much.

  • @MrJrhzues
    @MrJrhzues 9 месяцев назад +1

    TOP PERFORMERS BY YEAR

  • @matthewdufty606
    @matthewdufty606 Год назад +1

    I love this video. Thank you for making it ✅🌹💫

  • @brianligat9493
    @brianligat9493 11 месяцев назад +1

    You guys are wearing out my Like button.

  • @mariaclaramaya6298
    @mariaclaramaya6298 3 месяца назад +1

    Very helpfull video. ¡Congrats!

  • @gizmo928
    @gizmo928 11 месяцев назад

    Could the alternative solution be to change the ALLSELECTED() function in the Ranking measure 4:37 to ALL()?

    • @gizmo928
      @gizmo928 11 месяцев назад

      Nvm, I don’t think that will work, will still get a blank Amt value

  • @Bharath_PBI
    @Bharath_PBI 3 года назад +1

    That's Bananas and interesting to know the behaviour of summarizecolumns() and allselected (). Thank you. 👍

  • @sriramsundar4
    @sriramsundar4 3 года назад +1

    This is such an excellent explanation!! Thank you

  • @LuciusSullaFelix
    @LuciusSullaFelix 3 года назад +2

    I’ve booked marked this video so I can come back to this again as I didn’t follow the entire concept.

  • @johnjiang7456
    @johnjiang7456 Год назад +1

    It is a great video! I have a similar issue that uses a measure as a slicer( you use filter, a little different). I am not able to solve the problem. Like your example, if I would like to show all sales that ranked the top 2 for each year, not based on the sum for all years, how can I do it? That is to say, I would like to show values for Apple, Pear, and Banana 100, 200, blank for 2010, blank, 500, 350 for 2011, and 600, 100, blank for 2012. It would be greatly appreciated if you could offer some helps. Thanks

    • @SQLBI
      @SQLBI  Год назад

      See www.sqlbi.com/articles/filtering-the-top-products-alongside-the-other-products-in-power-bi/

  • @christianstork1049
    @christianstork1049 3 года назад +5

    Thanks for this detailed analysis. Worth its time already because of the methodology. However, to be honest, this seems more like a sophisticated illustration of a bug in Power BI. An internal optimization shouldn't justify occasional incorrect results nor cause extra work on behalf of the users. :-(

    • @porraloka31
      @porraloka31 3 года назад +3

      If powerBi had to calculate every single blank value it'd speed down the engine quite a lot and we'd complaining about how slow PowerBi is.

    • @Davide73
      @Davide73 2 года назад

      You are right - PowerBI is full of bugs that are "feature"... on the top of the list there is the so called "Auto Exist"; what is very funny is that MS Excel doesn't have it. It has been introduced in the PowerBI engine. The problem is that Microsoft and their evangelist will never admit them, so they will never be fixed.

  • @odeddror8916
    @odeddror8916 3 года назад

    What will happened if we use Top 2 Descending instead of ranking?

  • @marcostrevinorodriguez1254
    @marcostrevinorodriguez1254 2 года назад

    Do you give online courses?

    • @SQLBI
      @SQLBI  2 года назад

      Yes, you can find all our trainings at www.sqlbi.com/training

  • @pbihari0214
    @pbihari0214 3 года назад +1

    Thank you

  • @kalinduSekara
    @kalinduSekara 3 года назад +1

    Great 👍