Completed
18. Row and Filter Context Work Together
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
DAX Fundamentals in Power BI and Power Pivot - 2.5 Hour Course
Automatically move to the next video in the Classroom when playback concludes
- 1 1. Introduction and video topics
- 2 2. Topics in Video
- 3 3. Why we use DAX, M Code & Worksheet Formulas: What makes Each Special?
- 4 4. Review data, data structure, Excel files, Power BI Desktop files and pdf notes
- 5 5. What is DAX?
- 6 6. Comprehensive Discussion about Star Schema Data Model Components and how they interact with DAX: Columnar Database, Relationships, DAX Formulas, Hidden Columns
- 7 7. Calculated Columns
- 8 8. Row Context
- 9 9. Measures
- 10 10. Power BI Desktop Calculated Columns and Measures
- 11 11. Data Model PivotTable
- 12 12. Filter Context
- 13 13. COUNTROWS Function Super Charged COUNTIFS Function
- 14 14. Expanded Table Diagram
- 15 15. Implicit Measures
- 16 16. SUMX function and Iterator Functions to Replace Calculated Columns
- 17 17. Compare SUMX One Step Method to Calculated Column SUM Two Step Method
- 18 18. Row and Filter Context Work Together
- 19 19. Using Measures in other Measures
- 20 20. DIVIDE Function
- 21 21. CALCULATE Function to Change Filter Context
- 22 22. ALL Function to remove filters and get a Grand Total
- 23 23. % of Grand Total Measure
- 24 24. ALLSELECTED Function to get Filtered Grand Total and % of Filtered Grand Total
- 25 25. % of Parent Total DAX Measure: 1 ALLEXCEPT Function and 2 ALLSELECTED & VALUES
- 26 26. Compare ALL and VALUES Functions
- 27 27. CONCATENATEX Function
- 28 28. YOY Change Formula with SAMEPERIODLASTYEAR, CALCULATE, DIVIDE, HASONEVALUE and a special filtering Calculated Column in Data Table
- 29 29. Variables in DAX using VAR and RETURN
- 30 30. Calculated Helper Column to make Measure less complicated
- 31 31. Boolean Filters
- 32 32. Second Look at Filter Context
- 33 33. Overwrite Operation
- 34 34. FILTER & ALL for Boolean Filter
- 35 35. Logical Tests in FILTER and CALCULATETABLE Functions
- 36 36. FILTER & VALUES for Boolean Filter
- 37 37. KEEPFILTER to Convert Overwrite Operations to an AND Logical Tests
- 38 38. Boolean OR Logical Test with Double Vertical Bar Operator
- 39 39. Self Filtering Report with KEEPFILTER
- 40 40. Filter Context with KEEPFILTTERS
- 41 41. Boolean OR Logical Test with IN Operator
- 42 42. NOT Logical Test
- 43 43. Context Transition in Calculated Columns
- 44 44. Hidden CALCULATE in Measure
- 45 45. Context Transition in Iterator like AVERAGEX. Calculate Average Monthly Sales.
- 46 46. Context Transition and Filter Context
- 47 47. Context Transition Error: Iterate Over Table with Duplicate Errors
- 48 48. Context Transition: Correct Formulas and Incorrect Formulas
- 49 49. Context Transition Error: Iterate over Fact Table
- 50 50. Grain of Calculation & Iterator Functions for Transactional, Daily and Monthly Averages
- 51 51. Average using DISTINCTCOUNT to make a faster formula
- 52 52. Cardinality and Iterator Functions. See five examples of howto reduce cardinality and increase formula calculation speed
- 53 53. DAX Studio to time formulas. EVALUATE Command.
- 54 54. Complex Filter and Complex Filter Reduction Error from Overwrite process: KEEPFILTERS or Data Modeling?
- 55 55. KEEPFILTERS in Power BI Quick Measure
- 56 56. 12 Month Moving Average DAX Measure: CALCULATE, AVERAGEX, DATESINPERIOD, IF, MAX Functions
- 57 57. Table Filters in CALCULATE to go backwards across a Many-To-One Relationship
- 58 58. Unmatched Items in a Relationship
- 59 59. DAX Approximate Match Lookup
- 60 60. DAX to create Date Tables in Power BI using GENERATE, ROW, CALENDAR and more
- 61 61. Extract Data From Power Pivot Data Model using Existing Connections
- 62 62. Query View in Power BI Desktop
- 63 63. Video Summary and Conclusions
- 64 64. Closing and Video Links
