Optimizing callbacks in a SUMX iterator

Поделиться
HTML-код
  • Опубликовано: 23 окт 2023
  • How to optimize a common issue with SUMX iterators by reducing the number of callbacks in the expression.
    Article and download: sql.bi/816722?aff=yt
    How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
    The definitive guide to DAX: www.sqlbi.com/books/the-defin...
  • НаукаНаука

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

  • @user-xf1uh4ro2z
    @user-xf1uh4ro2z 3 дня назад +1

    Thank you. Very informative and interesting.

  • @businessinsights_AlexRobe
    @businessinsights_AlexRobe 8 месяцев назад +1

    Thanks again for a very insightful approach for this ever painful callback topic ! Never questioned the use of variables within the ADDCOLUMNS/SUMMARIZE approach -> one more lesson, that you have to question almost everything when optimizing complex DAX calculations you cannot make simpler -> just try it differently...🙏

  • @snipelite94
    @snipelite94 8 месяцев назад +1

    I enjoy this channel immensely!
    I've only been using Power BI and DAX for a short time, so I'm still in the beginner phase.
    Alberto is speaking to the ""advanced"" crowd, but I can follow about 75% of the content at least !

  • @pawewrona9749
    @pawewrona9749 8 месяцев назад +1

    Amazing video. As always, top level content. Thank you for very clear explanation.

  • @nikakalichava8012
    @nikakalichava8012 8 месяцев назад +1

    Thank you!

  • @Bharath_PBI
    @Bharath_PBI 8 месяцев назад +1

    Thank you 👍

  • @GagandeepSingh-db8eh
    @GagandeepSingh-db8eh 8 месяцев назад +1

    Great Work (Y)

  • @SageSam
    @SageSam 8 месяцев назад

    Hey, great vid as always. what software do you use to present these videos that allows you to zoom in and draw boxes, etc. ?

    • @SQLBI
      @SQLBI  8 месяцев назад +1

      ZoomIt: learn.microsoft.com/en-us/sysinternals/downloads/zoomit

    • @SageSam
      @SageSam 8 месяцев назад

      @@SQLBI thank u ❤️

  • @suseempal5280
    @suseempal5280 8 месяцев назад

    Can we optimise the callback that happens when we are calculating the cumulative total?
    I have a lot of values for which cumulative sum needs to be calculated.

  • @eladiobardelli3001
    @eladiobardelli3001 8 месяцев назад

    siempre a sido útil usar addcolumns + summarize con iteradores

  • @mienzillaz
    @mienzillaz 8 месяцев назад +1

    I wanted to ask this for so long..
    What keyboard you have there? 😊

    • @SQLBI
      @SQLBI  8 месяцев назад +1

      All the answers here: www.sqlbi.com/blog/alberto/2021/02/14/on-my-recording-gear/

    • @mienzillaz
      @mienzillaz 8 месяцев назад

      @@SQLBI thank you, that's a really nice workspace.

    • @wilsonman8661
      @wilsonman8661 5 месяцев назад

      @@SQLBI Alberto, I am inspired most by the last section on the page about your drive for improvement.