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:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

Download files here https://www.wiseowl.co.uk/power-bi/videos/dax-powerbi/dax-replace-keep-filters/

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 https://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!