The DAX CALCULATE Function

[Prohibitive]

The DAX CALCULATE Function
Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: aac, 44100 Hz
Language: English | VTT | Size: 1.89 GB | Duration: 4 section | 29 lectures | (3h 37m)
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

Requirements
Some basic DAX experience would be helpful
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.

Download
http://nitroflare.com/view/61317D175DFF7FE/The_DAX_CALCULATE_Function.part1.rar
http://nitroflare.com/view/1780F2FD1B8A68F/The_DAX_CALCULATE_Function.part2.rar

or
http://rapidgator.net/file/ac11c970717bedbd3d262879ce787992/The_DAX_CALCULATE_Function.part1.rar.html
http://rapidgator.net/file/e8351a58eb7786a3b9ba9b837a7a38c3/The_DAX_CALCULATE_Function.part2.rar.html

or
https://uploadgig.com/file/download/7293D8c792678605/The_DAX_CALCULATE_Function.part1.rar
https://uploadgig.com/file/download/2a0d8830d30803Fa/The_DAX_CALCULATE_Function.part2.rar