DAX for Power BI Part 5.3 - Replacing and Keeping Filters in Measures

Подписаться 208 тыс.

Просмотров 4,6 тыс.

50% 1

By Andrew Gould
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
/ @wiseowltutorials
Or you can click this link www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
Download files here www.wiseowl.co.uk/power-bi/vi...
This video shows how to both replace existing filters in a measure and how to retain an existing filter using the KeepFilters function.
Chapters
00:00 Topic list
00:28 The Basic Report
01:54 Replacing a Filter
03:32 Comparing the Two Measures
04:56 Replacing Multiple Filters
06:54 Comparing the New Measures
09:19 Creating a New Example
11:06 Keeping Existing Filters
12:38 Creating a List of Categories
14:18 Excluding Categories in a Measure
16:40 Using Multiple KeepFilters Functions
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!

Опубликовано:

5 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 26

@nikakalichava8012 11 месяцев назад

GooooOOOOOooOOODDD MOOOOOrrrnniiinng!!! Mr. Wise Owl has open a new video!!!! A great way to start a morning with your tutorials

@WiseOwlTutorials 11 месяцев назад

:D good morning to you too Nika! Happy to hear you're pleased with the video, thanks for watching!

@udusegbe 2 года назад

Loving your calm approach to explaining complex concepts in simple terms, with simple clear examples 🙂

@WiseOwlTutorials 2 года назад

Thank you so much, happy to hear that you're enjoying the videos!

@tejamarneni 11 месяцев назад

Good to hear from you Andrew.

@WiseOwlTutorials 11 месяцев назад

Hey Teja! Great to see you're still around!

@mePrafull 6 месяцев назад

Thank you very much this video resolves most of my queries with filter context

@WiseOwlTutorials 6 месяцев назад

Happy to hear that, thanks for watching!

@Teaseweb 11 месяцев назад

Please keep posting

@stickercode 2 года назад

As I am practising with the data you provide for DAX, I imagine runtime as sales, country as sales representative and genres as products. It feels like a more real life scenario that way :)

@WiseOwlTutorials 2 года назад

If you'd like a sales-based sample dataset you could use Microsoft's Adventureworks database for SQL Server docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms Many online tutorials use this database - I just find it really dull 😀

@shaileshvishwakarma3418 11 месяцев назад

Excellent tutorials on wise owl. Always best!!!

@WiseOwlTutorials 11 месяцев назад

Hey Shailesh! Happy to see you!

@Matt-zp9jg Год назад

Great content 😊

@WiseOwlTutorials Год назад

Thanks for the support Matt!

@santoshkiran5858 11 месяцев назад

Awesome 👍

@WiseOwlTutorials 11 месяцев назад

Thanks Santosh!

@piotrkuc8936 11 месяцев назад

Hi @WiseOwl, I was truly missing you. Hope you are doing well.

@WiseOwlTutorials 11 месяцев назад

Hey Piotr! Really happy to see you're still here!

@hadibq 2 года назад

so the Keepfilter imposes a context filtering from within a variable!!? if so, it's a really interesting feature... many filtering tricks can be done using a variable then 🙂

@WiseOwlTutorials 2 года назад

Indeed, it's useful stuff!

@ZOOTOPIAAAA 9 месяцев назад

hello andrew I am working on date table which i was trying to format the month ,but after formating am getting only two month value the other are missing but i have 12 month before formating do u have suggestions on this code date = ADDCOLUMNS(CALENDAR(DATE(2011,12,06),DATE(2014,12,05)) ,"year",YEAR([Date]),"quarter",CONCATENATE("qrt" , QUARTER([Date])),"month",FORMAT(MONTH([Date]),"mmm"),"weekday",WEEKDAY([Date]),"day",FORMAT(DAY([Date]),"dddd"))

@WiseOwlTutorials 9 месяцев назад

Hi! It looks like you're trying to format the result of the MONTH function. Try this instead: FORMAT([Date],"mmm") I hope it helps!

@ZOOTOPIAAAA 9 месяцев назад

@@WiseOwlTutorials tnx,, andrew it did help

@samirmishra507 2 года назад

when will be the Next video available on DAX area?

@WiseOwlTutorials 2 года назад

Hi Samir! You can see all of the DAX videos in this playlist ru-vid.com/group/PLNIs-AWhQzclPj5BGcckuyrOVqRD-7rIX There are 8 more currently available videos after this one and there will be more. I don't have a fixed release date though, sorry!