Channel: WiseOwlTutorials

Category: Education

Tags: free tutorialonline trainingpower bifree trainingbusiness intelligenceonline tutorialevaluation contextcalculated columnmeasuresmeasuredisplay folderrow contextfilter contextdaxtutorialcalculatequery contextwise owlmeasure table

Description: By Andrew Gould Download files here 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: youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join Or you can click this link 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 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!