[DAX] Power of CALCULATE inc ALL, DIVIDE & VAR | Power BI Basics
In this video, I'll be covering how to use CALCULATE to solve a problem when trying to get a % of a total, in this cases location and continent, with the added help of DAX functions, ALL, DIVIDE and VAR.
📁 Data Set used can be found here - https://data.world/deanchereden/covid...
📁 The Power BI Desktop pbix file can be found here -
https://data.world/deanchereden/covid...
▶️ How To Download, Import & View Data in Power BI
• How To Download, Import & View Data i...
🔖c h a p t e r s 🔖
00:00 - Intro
00:26 - Quick overview
01:45 - CALCULATE & ALL to get total of 'Total New Cases'
04:33 - DIVIDE to get % of total new cases per location
06:54 - The difference between DIVIDE and using /
09:15 - Issue when continent is added to the table
10:45 - VAR to combine 2 measures into 1
15:24 - Final table result
💌 My email - [email protected]
🌍 My website - https://www.deanchereden.com
🐦 Twitter - / deanchereden
🎵 Music - Misha, Jussi Halme - Higher https://chll.to/4ec991f9
🙌 Follow Misha
・ SoundCloud: https://chll.to/386e721b
・ Spotify: https://chll.to/5f0bc9ba
・ Apple Music: https://chll.to/5a239af3
・ Chillhop: https://chll.to/2b2bc310
🙌 Follow Jussi Halme
・ Spotify: https://chll.to/dd4a82d2
・ Apple Music: https://chll.to/4961c878
・ Chillhop: https://chll.to/eb17b45e
🎶 Listen to Chillhop Music - • Misha & Jussi Halme - Bliss (A Felici...