When To Use The CALCULATABLE Function - DAX Function Techniques

CALCULATETABLE can be a mind-bender when you're just starting out with Power BI. In this video tutorial, I look to cover the main ways you need to think about this particular function and how to use it in Power BI.

Good luck with this one.

****Video Details****
4:17 - calculating new customers using CALCULATETABLE
6:20 - evaluating a customer set
6:51 - adding a FILTER function
8:27 - calculating lost customers using CALCULATETABLE
8:43 - adding the EXCEPT function
***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-reference-guide-download
FREE - Power BI Resources - http://enterprisedna.co/power-bi-resources
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-dna-events-page/
*****Related Links*****
How To Understand Virtual Tables Inside Iterating Functions In Power BI - https://blog.enterprisedna.co/how-to-understand-virtual-tables-inside-iterating-function-in-power-bi-dax-concepts/
Deep Dive Into RANKX – DAX Formula Concepts In Power BI - https://blog.enterprisedna.co/deep-dive-into-rankx-dax-formula-concepts-in-power-bi/
Implementing DAX Measure Groups Into Your Power BI Reports - https://blog.enterprisedna.co/implementing-dax-measure-groups-into-your-power-bi-reports-modeling-review/
*****Related Course Modules*****
Mastering DAX Calculations - http://portal.enterprisedna.co/p/mastering-dax-calculations
Learning Summit Series - https://portal.enterprisedna.co/p/learning-summit-series
Advanced Analytics in Power BI - http://portal.enterprisedna.co/p/advanced-analytics
*****Related Forum Posts*****
Advanced Table Functions: CALCULATETABLE - https://forum.enterprisedna.co/t/advanced-table-functions-calculatetable/4957
Calculate Table - Subset Based On Unique Column Values - https://forum.enterprisedna.co/t/calculate-table-subset-based-on-unique-column-values/1821
Lost Customers Calculation - https://forum.enterprisedna.co/t/lost-customers-calculation/1345
For more calculatetable queries to review see here - https://forum.enterprisedna.co/search?q=calculatetable

Видео When To Use The CALCULATABLE Function - DAX Function Techniques канала Enterprise DNA