By Andrew Gould

Download files here https://www.wiseowl.co.uk/power-bi/videos/dax-powerbi/dax-basic-measures/

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!

This video provides an introduction to working with DAX measures in Power BI. You'll learn how to add measures to a data model and how measures differ from calculated columns. You'll see how to organise the measures in your model using display folders and measure tables. You'll be introduced to the concept of filter context and how this affects the result returned by a measure. You'll see some examples of using measures to format visuals rather than to simply display a value. You'll also see a basic example of manipulating the filter context to influence which values are used by a measure.

Chapters
00:00 Topic list
00:46 Importing the Data
02:17 Calculated Columns vs Measures
05:10 Measures and Filter Context
07:30 Display Folders and Measure Tables
12:00 Measures for Different Aggregations
15:04 Referencing One Measure in Another Measure
16:09 Calculating Colours with a Measure
20:51 Changing Other Formatting Properties
22:55 Modifying the Filter Context
26:51 Applying Other Filters

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!