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 remove filters in DAX measures using the All and RemoveFilters functions. You'll learn how to remove all the filters from a measure, how to remove filters from specific tables and how to remove filters from specific columns. You'll also see how to create measures which compare filtered and unfiltered values to show, for example, the percentage contribution of values to totals.
Chapters
00:00 Topic list
00:30 The Data Model
01:46 How Filters Affect Measures
04:45 Removing All Filters in a Measure
08:18 Comparing Filtered and Unfilterd Measures
10:24 Removing Filters from a Single Table
14:24 Removing Filters from Multiple Tables
18:15 Setting Up a New Example
20:14 Removing Filters from a Single Column
22:56 Removing Filters in CalculateTable
24:05 Removing Filters from Multiple Columns
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