In this tutorial, Sam show how to write an advanced DAX formula to harvest (capture) a selection made within a slicer visual then integrate that back into other measure calculations.
***** Video Details *****
00:00 Introduction
00:28 Data Set
01:07 Adding Percentage Change To The Total Sales Table
02:49 Turning Percentage Change Table Into A Slicer
04:20 Fixing An Error Resulting From Lack Of Selection
05:44 Creating Total Scenario Sales Measure
06:19 Clicking Different Selections In the Slicer To Get Corresponding Results
06:36 Other Uses For Harvesting Slicer Selections
***** 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 – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://www.enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://www.enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://www.enterprisedna.co/enterprise-dna-events-page/
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial