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 explains how to use the AllSelected and AllExcept functions to remove filters in your DAX measures. You'll learn how to remove all the filters and only the specified filters using the All function; how to remove all of the filters applied by a Power BI visual using the AllSelected function; and how to remove all filters except for the ones you specify using the AllExcept function.
Chapters
00:00 Topic list
00:34 01 The Basic Report
02:47 Removing All Filters in a Measure
05:23 Applying Filters Using Slicers
09:13 Removing Multiple Specific Filters
13:04 Comparing Values with the Visual Total
14:51 Comparing Values with Subtotals
15:52 Removing Visual Filters with the AllSelected Function
17:55 Changing the Fields in the Visual
18:43 Setting Up a New Example
19:38 Removing Filters with AllExcept
22:04 The Effect of Applying Filters
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