DAX for Power BI Part 5.2 - Removing Filters in Measures

[@rachelroos8878]

These tutorials are so helpful. Thanks for the explanation of the different ways to remove filters.

[@WiseOwlTutorials]

Happy to hear that you found it useful, thanks for watching!

[@msantosh1220]

Thanks!

[@msantosh1220]

Thank Andrew for this video

[@WiseOwlTutorials]

Thank you Santosh for your support!

[@msantosh1220]

Hi Andrew, The best explanation to remove filters from a measure. Thank-you to bring us this informative video

[@WiseOwlTutorials]

Thanks Santosh!

[@tejamarneni]

Hi Andrew. Good to hear from you!!

[@WiseOwlTutorials]

Thanks Teja!

[@AZ_German]

Amazing stuff. Because of you I feel much more confident in my DAX skills. Will join the channel to see the remaining videos 👍🏻

[@WiseOwlTutorials]

Thanks for your support Alexander!

[@mePrafull]

Awesome tutorial on Removing FIlters, thank you very much

[@WiseOwlTutorials]

You're welcome, thanks for watching!

[@markbocsor3704]

This series is so #excellent :-) Thanks a lot Andrew

[@WiseOwlTutorials]

Cheers Mark, happy to hear you're enjoying it!

[@hadibq]

Thanks Andrew, all clear so far 👍you're the best!

[@WiseOwlTutorials]

Thanks so much for your support Hadi!

[@nikakalichava8012]

Thanks a lot!

[@najobsodar7528]

Excellent tutorial, many thanks....

[@WiseOwlTutorials]

You're very welcome, thanks for watching!

[@kebincui]

Excellent tutorial 👍👍

[@WiseOwlTutorials]

Thanks for watching!

[@marcelofreitas4593]

Hello, Andrew! Happy New Year for you and the Wise Owl crew! What news can we expect for this opening year? Maybe a playlist about Power Apps and Power Automate? See you soon!

[@WiseOwlTutorials]

Happy New Year Marcelo! This year will see more DAX videos, a new Office Scripts course, and, maybe, depending on whether Andy Brown has the time, some Power Automate videos too!

[@magibis7519]

Excellent, Thanks! Thanks Thanks Thanks Andrew

[@WiseOwlTutorials]

You're very welcome, thanks for your support!

[@ellukayou]

This is gold to me

[@WiseOwlTutorials]

Happy to hear that you found it useful Luciano, thanks for watching!

[@Robertyaro]

Hi Andrew. Mighty thanks for your high quality and easy to follow tutorials. You're making Excel gurus all along, and I feel endebted to you for that. Just a question. Is it possible to sep up an Excel workbook in such a way that many people can connect to it simultaneously?

[@WiseOwlTutorials]

Hi Lossan! I'm happy to hear that you've found the videos useful! You could store your Excel workbook in a SharePoint Team Site or OneDrive. This article might be helpful www.thepoweruser.com/2019/04/04/connecting-to-files-in-sharepoint-onedrive-with-power-bi-power-query/ I hope it helps!

[@Robertyaro]

@@WiseOwlTutorials Hi, Andrew. Thank you very much for your quick answer. I'll sure go for the link and exploite it. Send you feedback of how it works for me. Bye!

[@VBAbyMBA]

Hi Andrew! I find your videos, easy to learn. Can you please extend/Add javascripts for google sheets? this maybe upgraded version of VBA. For the starter you can compare both Excel VBA and google scripts so that a VB person can also understand it. I hope every VBA guy need it to upgrade their skills to compete, what do you think?

[@WiseOwlTutorials]

Thanks for the suggestion! We don't tend to use Google Sheets so it's unlikely we'll have videos on this topic in the near future. We may have something on Office Scripts if time allows!

[@shoaibrehman9988]

Hi Andrew gr8 stuff. Could you guide us from your expertise to calculate sales by week numbers. Means Sales in each week. Like wk 2 ,3....10. Only from DAX measures not from drag and drop sales in Matrix and tables by calendar week. Please if suitable in future videos. Thanks

[@fasasimosunmola1530]

Hello, I tried solving one of your online questions, "Sadly, your company has appointed a new FD who insists that you should report in thirds, rather than quarters. The thirds should be named after his 3 pet cats", but I keep getting blank in my tree map. What Can I do please, I connected using the purchase date.

[@vitkotomas5768]

Hello WiseOwl Team, is everything going well? You have not published a video since a couple of months.

[@WiseOwlTutorials]

Hi Vitko! Yes, we're well thanks, just very busy delivering training courses here in the UK. More videos are planned, we just need time to make them!

[@mydreams7104]

How can i join to later videos. It is locked. How to purchase perks. It is not working.

[@WiseOwlTutorials]

Hi! Are you able to use this link to join? kzbin.info/door/bi5G5PjWBaQUFy7XU_O7ywjoin If not, it may be that channel membership isn't available in your location at the moment.

[@WildGuesser]

What if i want some filters to be aplied and some not?

[@WiseOwlTutorials]

Hi Hugo! You can remove either all the filters, all the filters applied to a specific table, or all the filters applied to a specific column, as shown in the video. The next two videos in the playlist show how to use functions like AllSelected and AllExcept kzbin.info/aero/PLNIs-AWhQzclPj5BGcckuyrOVqRD-7rIX

[@nidhikaikadi8652]

Suggest me a way to format the value to two decimal places in RDLC report through AL Code in Business Central.and Of aslo of Sum or of Multiplication Expression Textbook Field in RDLC report. Please reply me as soon as possible

[@Teaseweb]

Why stop posting videos ?