DAX for Power BI Part 5.4 - Removing Filters with AllSelected and AllExcept

[@janezklun]

Hi Andrew, great tutorial as always, thank you

[@WiseOwlTutorials]

You're very welcome as always Janez, thanks for watching!

[@tejamarneni]

Thank you Andrew for the video. What's next in the series?

[@WiseOwlTutorials]

Thanks Teja! The next DAX video for non-subscribers is Part 5.5 The Crossfilter Function. The next videos for subscribers are Part 8.3 Parameter Tables and Disconnected Slicers and Part 8.4 Disconnected Slicers and Conditional Formatting which I'll be working on this weekend!

[@tejamarneni]

I'm sorry you have to work on weekend. Have a good day.

[@WiseOwlTutorials]

@@tejamarneni Thanks Teja!

[@ismailgultekin9768]

Great tutorial Thanks!!!

[@WiseOwlTutorials]

You're welcome, thanks for watching!

[@mePrafull]

Thank you very much!

[@WiseOwlTutorials]

You're very welcome, thanks for watching!

[@x15g]

Hey, what if you want to reference multiple columns from different tables in the ALLEXCEPT function? How would you do that please? Thank you

[@WiseOwlTutorials]

Hi! You can reference columns from other tables, for example: Total Run Time Oscars Only = CALCULATE( [Total Run Time], ALLEXCEPT( Film, Film[OscarNominations], Film[OscarWins], Country[Country] ) ) Is there something specific you're trying to do?

[@x15g]

@@WiseOwlTutorials Thank you!

[@Ravi_Singhal25]

Hi Andrew, This is really helpful. I have some questions related to circular dependency, can you cover this topic too. And I have created a measure example - selectedvalue(xyzColumn) but I couldn't not use this measure with other column of table until I used "xyzColumn" field . Any alternative of that?

[@WiseOwlTutorials]

Hi Ravi! We'll certainly have a video which covers the SelectedValue function (and other related functions such as HasOneValue). I hadn't planned a video on circular dependencies but I'll add this to the list.

[@Ravi_Singhal25]

@@WiseOwlTutorials Thanks in Advance sir

[@Rocks5033]

Thanks buddy

[@WiseOwlTutorials]

You're welcome Afzal, thanks for your support!

[@mkkk8971]

was this reuploaded? something changed in the DAX logic and it needed to be updated?

[@WiseOwlTutorials]

Hi! No, it was released in early access for channel members and then later released publicly. I hope that helps!

[@Rocks5033]

Buddy please create a play list for. JSon

[@WiseOwlTutorials]

I'd like to! But it's not one of the main things we do so sadly it's not likely to happen any time soon!

[@saifulislam-xq9wh]

improve ur sound quality, very annoying