DAX for Power BI Part 5.2 - Removing Filters in Measures

[@tejamarneni]

Hi Andrew. Good to hear from you!!

[@WiseOwlTutorials]

Thanks Teja!

[@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!

[@markbocsor3704]

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

[@WiseOwlTutorials]

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

[@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!

[@nikakalichava8012]

Thanks a lot!

[@najobsodar7528]

Excellent tutorial, many thanks....

[@WiseOwlTutorials]

You're very welcome, thanks for watching!

[@mePrafull]

Awesome tutorial on Removing FIlters, thank you very much

[@WiseOwlTutorials]

You're welcome, thanks for watching!

[@hadibq]

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

[@WiseOwlTutorials]

Thanks so much for your support Hadi!

[@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!

[@kebincui]

Excellent tutorial 👍👍

[@WiseOwlTutorials]

Thanks for watching!

[@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!

[@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!

[@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

[@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.

[@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

[@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

[@Teaseweb]

Why stop posting videos ?