Uploaded September 2024 | Updated November 2026, 2 hours ago
π Unlock AI for $10 per month: https://ntn.so/Chandoo
~
Power BI is like an iceberg. There is a little we can see, but most of its complexity and technology is hidden underneath. So, in this video, let me demystify Power BI by explaining 50 of the most common and confusing jargon you hear. You will learn how the architecture of Power BI technology looks by the end of this video.
I have explained all the main areas of Power BI in the video:
Power BI
Power BI service
Power Query
Power Pivot
Cloud
Data infrastructure
Fabric
Automation
and AI
This is the Part 1 of the 2-part video series.
In this video, the following terms are explained:
Connections
Query
Table
OneLake
Warehouse
Database
Datamart
Dataverse
SQL
Transformation
Refresh
Query Folding
M Language
Close & Load
Query Parameter
Power Pivot
Modeling
Data vs. Semantic Modeling
DAX
Measure
KPI, Metric & Calculation
Relationship
One to many relationship
Filter Direction
Star Schema
Snowflake Schema
Evaluation Context
Power BI Canvas
Visual
Report
Dashboard vs. Report
Filters
Slicer
Drillthrough
Interaction
Paginated Report
Conditional Formatting
π₯ The second part is here - youtu.be/6eQL_GnFXls
β Video Chapters:
================
0:00 - Power BI is like an iceberg
1:02 - Power BI as a mind-map
2:57 - The data layer of Power BI (power query, connections, M etc.)
11:30 - How I learn and remember technical concepts
13:40 - Calculation layer of Power BI (semantic modelling, relationships, DAX, Power Pivot etc.)
20:14 - Reporting layer of Power BI (visuals, slicers, filters, interactions, drillthrough etc.)
25:34 - The second part of the video
π‘ More Power BI:
===============
π₯ Advanced Power BI Course - chandoo.org/wp/power-bi-course
Learn Power BI with me and master the technology.
Getting started with Power BI - youtu.be/9tF1IrfLflg
Power BI end-to-end project - youtu.be/uwe8C7K8fXY
How to use Power Query - youtu.be/MMdcczmULrU
How to use Power Pivot - youtu.be/PQ5lALdFHCU
What is Fabric - youtu.be/--cK4A2djoA
20+ Data & BI Terms explained - youtu.be/a906b80lCE8
For more info:
===========
π my website chandoo.org/wp
π» my course chandoo.org/wp/power-bi-course
π€ my linkedin linkedin.com/in/purnaduggirala
π· my insta instagram.com/chandoo.xlsx
π§ get in touch chandoo.org/wp/contact
~
#powerbi #jargon #chandoo
π Unlock AI for $10 per month: https://ntn.so/Chandoo
~
Power BI is like an iceberg. There is a little we can see, but most of its complexity and technology is hidden underneath. So, in this video, let me demystify Power BI by explaining 50 of the most common and confusing jargon you hear. You will learn how the architecture of Power BI technology looks by the end of this video.
I have explained all the main areas of Power BI in the video:
Power BI
Power BI service
Power Query
Power Pivot
Cloud
Data infrastructure
Fabric
Automation
and AI
This is the Part 1 of the 2-part video series.
In this video, the following terms are explained:
Connections
Query
Table
OneLake
Warehouse
Database
Datamart
Dataverse
SQL
Transformation
Refresh
Query Folding
M Language
Close & Load
Query Parameter
Power Pivot
Modeling
Data vs. Semantic Modeling
DAX
Measure
KPI, Metric & Calculation
Relationship
One to many relationship
Filter Direction
Star Schema
Snowflake Schema
Evaluation Context
Power BI Canvas
Visual
Report
Dashboard vs. Report
Filters
Slicer
Drillthrough
Interaction
Paginated Report
Conditional Formatting
π₯ The second part is here - youtu.be/6eQL_GnFXls
β Video Chapters:
================
0:00 - Power BI is like an iceberg
1:02 - Power BI as a mind-map
2:57 - The data layer of Power BI (power query, connections, M etc.)
11:30 - How I learn and remember technical concepts
13:40 - Calculation layer of Power BI (semantic modelling, relationships, DAX, Power Pivot etc.)
20:14 - Reporting layer of Power BI (visuals, slicers, filters, interactions, drillthrough etc.)
25:34 - The second part of the video
π‘ More Power BI:
===============
π₯ Advanced Power BI Course - chandoo.org/wp/power-bi-course
Learn Power BI with me and master the technology.
Getting started with Power BI - youtu.be/9tF1IrfLflg
Power BI end-to-end project - youtu.be/uwe8C7K8fXY
How to use Power Query - youtu.be/MMdcczmULrU
How to use Power Pivot - youtu.be/PQ5lALdFHCU
What is Fabric - youtu.be/--cK4A2djoA
20+ Data & BI Terms explained - youtu.be/a906b80lCE8
For more info:
===========
π my website chandoo.org/wp
π» my course chandoo.org/wp/power-bi-course
π€ my linkedin linkedin.com/in/purnaduggirala
π· my insta instagram.com/chandoo.xlsx
π§ get in touch chandoo.org/wp/contact
~
#powerbi #jargon #chandoo





![Learn DAX ALL() Functions in Just 30 Minutes [POWER BI Essentials]
Learn the when and how to use ALL function in Power BI. We are also going to cover the difference between ALL, ALLSELECTED, REMOVEFILTERS, ALLEXCEPT and SELECTEDVALUE functions with real-world examples of when and how to use them for data analysis.
What we are going to learn:
1) Explanation of the data model
2) How and why we use ALL funciton
3) Using ALL(table) vs. ALL(table[column]) with a real-world example
4) DAX Query View to debug and check measures
5) Understanding the evaluation context and why sometimes doesnt work
6) ALL vs. ALLSELECTED
7) ALL vs. ALLEXCEPT
8) ALL vs. REMOVEFILTERS
9) Understanding ALLCROSSFILTERED & ALLNOBLANKROW
10) Practical Example #1: Rank among all vs. Rank in a specific category (ALL with RANKX)
11) Example #2: How a specific month sales vary compared to all months sales
π Sample Power BI File:
Blank file: https://github.com/chandoo-org/Power-BI/raw/refs/heads/main/sample%20files/All%20the%20ALL%20functions-blank.pbix
Completed file (available only for my Power BI Course members): join here π https://chandoo.org/wp/power-bi-course/
π Video Topics:
0:00 - Understanding all the ALL functions in DAX (Power BI)
0:45 - Why and when to use ALL function
3:01 - Using ALL() with a table vs. table column
4:50 - DAX Query View and how it helps you with understanding calculations
6:10 - The key to understanding DAX - Evaluation Context
9:49 - ALL vs. ALLSELECTED
13:27 - ALL vs. ALLEXCEPT
17:20 - ALL vs. REMOVEFILTERS
18:40 - ALLCROSSFILTERED and ALLNOBLANKROW
22:14 - Rank in all vs. Rank in Category - RANKX + ALL Example
26:01 - Specific month sales vs. all month sales - Variance Analysis
πΊ More Power BI Videos and Playlists
π₯ Complete Power BI Course: If you want to learn Power BI including Power Query, DAX, Data Modeling and Dashboards - Check out my comprehensive Power BI Course - https://chandoo.org/wp/power-bi-course/
Use Code SAVE100 to get upto $100 (or Rs 6,000) discount on my Power BI + Excel bundle.
πΆ Power BI Videos playlist - https://www.youtube.com/playlist?list=PLmejDGrsgFyClheDmsfikqOt0no-TKArs
πΆ DAX + Power Pivot Playlist - https://www.youtube.com/playlist?list=PLmejDGrsgFyCm0i58VobdriBr FA8lYh
~
#powerbi #dax Learn DAX ALL() Functions in Just 30 Minutes [POWER BI Essentials]](https://i.ytimg.com/vi/o1WPhrvwjLQ/mqdefault.jpg)




