By Andrew Gould

Download files here https://www.wiseowl.co.uk/power-bi/videos/dax-powerbi/dax-values-hasonevalue-selectedvalue/

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!

See the full DAX for Power BI playlist here https://youtube.com/playlist?list=PLNIs-AWhQzclPj5BGcckuyrOVqRD-7rIX

This video shows you how to reference the values of a column in a measure expression. You'll learn how to use the Values or Distinct functions to return a list of unique values for a column. You'll see how to use HasOneValue or HasOneFilter to check if only one unique value has been returned. You'll also learn how to use the SelectedValue function to replace a combinatiion of the If, HasOneValue and Values functions. The video also explains how to use these functions for several practical examples in Power BI, including creating dynamic visual titles with sync slicers and drill through filters, as well as how to create a basic disconnected slicer.

Chapters
00:00 Topic list
00:59 The Basic Setup
02:08 A Reminder of Row Context
04:01 Referring to Values in a Measure
07:50 Dealing with Multiple Values
10:50 Multiple Values in a Total Row
12:46 HasOneValue vs HasOneFilter
16:10 The SelectedValue Function
18:26 Dynamic Visual Titles
23:32 Using Sync Slicers
27:06 Using Drill Through
31:35 Creating a Drill Through Button
34:00 Making the Button Text Dynamic
35:49 Improving the Button Text
38:45 Creating a Second Button
40:05 Creating a Disconnected Slicer
43:03 Creating a Single Drill Through Button
45:09 Tidying Up the Results
47:58 Adding New Options to the Slicer

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!