DAX Filter Context in 1 Hour

แชร์
ฝัง
  • เผยแพร่เมื่อ 1 ต.ค. 2024

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

  • @thiagofraletti4220
    @thiagofraletti4220 3 ปีที่แล้ว +15

    Marco Russo is incredible, his explanation is so clear even explaining complex topics.

  • @jianhongsong6140
    @jianhongsong6140 2 ปีที่แล้ว +2

    Best explanation of DAX filter on TH-cam, thank you Marco!

  • @Personal803
    @Personal803 2 ปีที่แล้ว +2

    Best content I have seen so far on Filter Context, Row Context and Context Transition. Though, I would look for more on Context transition to grab the concept.

  • @mau_lopez
    @mau_lopez 2 ปีที่แล้ว +2

    This is a fantastic video, in fact the concepts here are like the corner stone to understand and work the right way with DAX. I wish I had watched this video time ago, it would have saved me a lot of headaches. Thanks so much to Mr. Russo, awesome, and to MD for sharing!

  • @tomaszreklamy1592
    @tomaszreklamy1592 ปีที่แล้ว

    Is there any page in internet which lists all operations which are the same - as SUM and SUMX described here?

  • @RMKserve
    @RMKserve 2 ปีที่แล้ว +1

    I was searching for the same answers and eventually find the differences between calculated columns and new measure in terms of row context.thats great explanation 👌👌👌❤️

  • @DeviMahendra
    @DeviMahendra 2 ปีที่แล้ว +1

    Extremely insightful session. One of the best videos to understand DAX. Thank you Marco.

  • @marlonvandekelft4978
    @marlonvandekelft4978 2 ปีที่แล้ว +1

    Thanks Marco! I learned an important nuance in this video: explicit filters override the implicit filter of the SAME column which leads to recurring results ONLY in case this filter context is used twice in a pivot table 41:47.

  • @bhakthasingh8198
    @bhakthasingh8198 3 ปีที่แล้ว +1

    Thank you so much, Marco for helping us understand the basics of filtering which are crucial for a strong and simple data modeling.

  • @anacarolinacastro5985
    @anacarolinacastro5985 2 ปีที่แล้ว

    Hi there,
    I need your help. I add 2 slider to my PowerBI visual, but it just could be displayed if the number of participants is bigger then 3. How could I apply this condition to my sliders? Thanks for your help!

  • @sarajvo2010
    @sarajvo2010 3 ปีที่แล้ว +1

    So great and simple explanation of DAX concepts.

  • @augustotanaka
    @augustotanaka 3 ปีที่แล้ว +1

    Thanks akk you guys and specially Marco!

  • @ronand8936
    @ronand8936 2 ปีที่แล้ว

    Marco - I build a lot of tabular models in SSAS and we have a team that builds out Power BI reports consuming these tabular models. Often due to time constraints or for experimentation we want the power bi developers to build their own measures in power bi effectively sub classing the underlying measures in the TM. Usually this method works fine but because of the implicit CALCULATE wrapped around all measures sometimes the report developer can't do this and they have to go back to first principles and completely author the measure from scratch and can't simply tweak/ modify / subclass the original TM measure. This is annoying . Is there anyway to remove context transition (I suspect not) or is there any plans to extend DAX in the future to allow this happen? Context transition is useful but I keep finding example of where I would like it not to happen .

  • @MrDauNgo
    @MrDauNgo 3 ปีที่แล้ว +1

    thanks you - my "online" teacher -

  • @rickyzeng5907
    @rickyzeng5907 2 ปีที่แล้ว

    Thanks a lot for sharing. I always feel confused about these filters, contexts thing in DAX. Now it is clear!

  • @bulbulahmed3098
    @bulbulahmed3098 ปีที่แล้ว

    ❤❤❤

  • @TheSQLPro
    @TheSQLPro 2 ปีที่แล้ว

    Really good session helped me understand DAX better.

  • @youssoufsougueh396
    @youssoufsougueh396 3 ปีที่แล้ว +1

    Thanks Marco Russo

  • @saharlatifi3510
    @saharlatifi3510 2 ปีที่แล้ว

    Great explanation. Thank you Marco.

  • @seanmen4141
    @seanmen4141 3 ปีที่แล้ว

    Thanks for the tutorial. Could you also share the power point?

  • @2404Pepe
    @2404Pepe 3 ปีที่แล้ว

    La flaca está tomando mate??? una genia!!!

  • @michafabich9213
    @michafabich9213 2 ปีที่แล้ว

    incredible, learnt a lot

  • @Hurairahgiri
    @Hurairahgiri 2 ปีที่แล้ว

    Thank you Marco!

  • @kennethstephani692
    @kennethstephani692 3 ปีที่แล้ว

    Terrific Video!