A New Look At CALCULATE - Power BI
In this video, we’ll take a look at the very basics of CALCULATE. In order to understand how CALCULATE works, you’ll need to have a good concept of Row Context and Filter Context. Many of Enterprise DNA members struggle with using CALCULATE, so I’ll try to simplify the key ideas in order to use and maximize this function.
Mudassir
**** Video Details ****
00:00 Introduction
00:59 The data set
01:22 The model
01:51 Row context
03:15 SUMX iterator
04:24 Filter context
06:53 Activate the filter context
14:04 Time intelligence calculation
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - http://enterprisedna.co/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...
#EnterpriseDNA #PowerBI #PowerBITutorial #DAX #DAXTutorial #CALCULATE #RowContext #FilterContext