Companies Home Search Profile
TrainingHub TrainingHub

The DAX CALCULATE Function

Focused View

Randy Minder

3:37:28

252 View
  • 1. Introduction.mp4
    01:24
  • 2. The main data model.mp4
    06:10
  • 3. Additional data models.mp4
    03:30
  • 1.1 Store Sales.zip
  • 1. Filter context - Part 1.mp4
    12:37
  • 2. Filter context - Part 2.mp4
    08:07
  • 3. Row context.mp4
    08:12
  • 4. Context transition - Part 1.mp4
    13:01
  • 5. Context transition - Part 2.mp4
    07:18
  • 6. A Power Query tip.mp4
    04:36
  • 1. Introduction.mp4
    05:21
  • 2. Filters.mp4
    12:05
  • 3. A filters summary.mp4
    02:21
  • 4.1 Contoso.zip
  • 4.2 Queries2.zip
  • 4. Order of execution.mp4
    10:49
  • 5. Modifiers - Part 1 (ALL and VALUES).mp4
    15:06
  • 6.1 Queries.zip
  • 6. Modifiers - Part 2 (ALL and VALUES).mp4
    12:37
  • 7.1 Queries.zip
  • 7. Modifiers - Part 3 (KEEPFILTERS).mp4
    08:55
  • 8.1 Files.zip
  • 8. Modifiers - Part 4 (USERELATIONSHIP).mp4
    08:05
  • 9.1 Queries.zip
  • 9. Modifiers - Part 5 (CROSSFILTER).mp4
    08:42
  • 10.1 Contoso.zip
  • 10. Modifiers - Part 6 (ALLSELECTED).mp4
    12:41
  • 11. A summary of CALCULATE.mp4
    03:06
  • 12.1 Expanded Tables.zip
  • 12. Expanded tables.mp4
    09:52
  • 13.1 Files.zip
  • 13. CALCULATETABLE.mp4
    09:47
  • 1. Questions to test your knowledge.mp4
    13:26
  • 2.1 Contoso.zip
  • 2. Exercise 1.mp4
    04:20
  • 3. Exercise 2.mp4
    01:58
  • 4.1 Contoso.zip
  • 4. Exercise 3.mp4
    02:46
  • 5.1 Contoso.zip
  • 5. Exercise 4.mp4
    03:43
  • 6.1 Contoso.zip
  • 6. Exercise 5.mp4
    03:10
  • 7.1 Query.zip
  • 7. Exercise 6.mp4
    03:43

    • Description

    CALCULATE is the most important function in the DAX language. This course covers the function in depth.

    What You'll Learn?

    • The evaluation context - Filter context and row context
    • Context transitioning - How it can cause havoc with your CALCULATE function
    • The many roles filtering plays in the CALCULATE function
    • CALCULATE modifiers
    • The amazing ALLSELECTED function and the mysterious shadow filter context
    • How to simulate outer (external) filter contexts when developing DAX expressions using CALCULATE

    Who is this for?

  • All DAX developers

    • More details

    Description

    The DAX CALCULATE function is THE core DAX function that every DAX developer uses but probably has little understanding of what's going on 'under the hood' and the kinds of problems he/she can run into.

    It's very simple in its concept, extremely powerful but full of subtleties to be aware of to get the most benefit from it and to stay out of trouble.

    This 3.5 hour Udemy course on the CALCULATE function starts with a deep dive into the evaluation context, which must be thoroughly understood when working with CALCULATE. We then explore filtering, context modifiers and order of execution. We then spend a fair amount of time discussing the mystery function that is CALCULATETABLE and when to use it. The course is wrapped up with 20 questions to test your knowledge.

    When you complete this course you will have a solid grasp on how to use this amazingly simple, in appearance, yet exceedingly powerful, DAX function.

    Who this course is for:

    • All DAX developers

    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    Category

    DAX

    Randy Minder
    Randy Minder
    Instructor's Courses
    Microsoft Certified Professional:Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI (January 2019 - 80% score)Snowflake Core Certification Exam (April 2021 - 90% score)Seasoned database engineer (OLTP, data warehouses, operational data stores), tabular modeling, business intelligence. Power BI, Snowflake and KQL. 20 years of software development using a variety of Microsoft technologies, mostly C#. 2016 Nominee for the First Solar Business Enablement CEO Award for Analytics Tools & Methods Infrastructure.StackOverflow reputation of 45,000 (top 1%)
    Udemy
    Udemy
    View courses Udemy
    Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
    • language english
    • Training sessions 29
    • duration 3:37:28
    • Release Date 2022/12/11

    Courses related to DAX

    Power BI DAX Tutorial
    UdemyPower BI DAX Tutorial
    3:04:44
    05/09/2024
    Microsoft SQL MDX and DAX
    CBT NuggetsMicrosoft SQL MDX and DAX
    2:06:13
    07/18/2023
    Harnessing Power BI for Effective Business Intelligence
    Udemy Enterprise DNA
    Enterprise DNA
    Harnessing Power BI for Effective Business Intelligence
    6:14:12
    10/01/2023