How to Use Calculate & Filter() in Power BI to Change Filter Context

  Рет қаралды 7,369

The Power BI Guy

The Power BI Guy

3 жыл бұрын

In this video we will cover how you can use Calculate & filter to change the filter context with your data. I go through a couple scenerios where I demonstrate the difference between the two and how to apply some if logic to filters.
-
-
-
-
-
-
-
-
-
-
-
-
Search Tags: Microsoft PowerBI, Microsoft Power BI, PowerBI, Power BI, PowerBI for Desktop, PowerBI Pro, PowerBI Online, PowerBI Tutorial, Power BI Tutorial, The Best PowerBI Design, Inspiring and Amazing PowerBI Design, PowerBI Dashboard, PowerBI Data Visualization, Power BI Data Analytics, Power BI Analysis, PowerBI Report and Dashboard Design, Easy PowerBI Design, Easy PowerBI Data Visualization, Easy PowerBI Tutorial, Power BI End to End Tutorial, PowerBI End to End Design, Quick and Easy, Power BI Tutorial From Beginner to Pro Desktop to Dashboard, PowerBI Data Modeling, PowerBI Measures, What is PowerBI, How to use PowerBI, Is PowerBI easy to learn, PowerBI vs Tableau, PowerBI Online vs Tableau Online, Power BI Tutorial for Beginners - Basics and Beyond, Power BI Tutorial for Beginners - Getting Started, Creating a Power BI report in under 5 mins, Analyze & Visualize Data with Power BI, Mastering Microsoft Power BI - Introduction to Power BI, Power BI Tutorial For Beginners | Introduction to Power BI, PowerBI Navigator, PowerBI Navigation, Data modelling in Power BI Desktop, Power BI Tutorial Videos, Power BI Advanced Tutorial, PowerBI for Freelancers, Power BI Slicers vs Filters, Drilling into drillthrough in Power BI Desktop, Power BI - Dashboards vs. Reports, Power BI Bookmarks, Selections and Toggles, Power BI Beginner Tutorial, How to build Power BI Dashboards, Design, Publish and Share a Sales Dashboard in Power BI, Power BI Desktop for Beginners: Create your first Power BI report and dashboard in 10 minutes, PowerBI For Newbies, PowerBI Ninja Tutorial, How to Design Visually Stunning Power BI Reports, PowerBI Basic Dashboard and Design, Microsoft Power BI: Building spectacular Power BI dashboards, PowerBI Infograph, Easily create infographics in Power BI with infographics desginer, Power BI Dashboard & Reports - Sales Analysis, Top 5 DAX tricks for super effective Power BI dashboards, Power BI visualization best practices, How to create PowerBI Dashboard Reports, Top 10 Most Effective Power BI Dashboard Tips & Tricks In, Design, Publish and Share a Sales Dashboard in Power BI, Power BI - Dashboards vs. Reports, How to Create Beautiful Power BI Dashboards Using the Power Pattern, PowerBI Tips & Tricks for Stunning Power BI Reports!, Power BI Dashboard & Reports - Inventory Analysis, PowerBI for Sales and Marketing, PowerBI for Supply Chain, PowerBI for Inventory, PowerBI for Supply Chain, PowerBI for Purchasing, PowerBI for Warehouse, PowerBI for Logistics, PowerBI for HR, PowerBI for Team Performance and Dashboard, PowerBI for Managers, PowerBI for Employees Team Performance, PowerBI for Excel Users, PowerBI PowerPivot, Import Data to PowerBI, PowerBI to Stores, The Best PowerBI Design, Build Top Amazing PowerBI Design, How to Design Visually Stunning Power BI Reports, Power BI Report Design Tips And Inspiration, Design a Navigation Panel - Power BI Desktop, Power BI Tutorial | Creating Landing Page using Dashboard and Tiles, Power BI Custom Visuals - Infographic Designer, Basic Dashboard in PowerBI, The Best PowerBI, PowerBI Design, Microsoft PowerBI, Free PowerBI Design and Downloads, Free download PowerBI PBIX File, The Microsoft PowerBI Desktop, Power BI App Navigation, Designing Impactful Reports in Power BI (Free Webinar), Free Download, Free Design, PowerBI Template and pbix, Power BI - Do it Yourself Tutorial - Dashboard Design, Create a custom KPI Card in a Power BI report, Introduction to Power BI Designer, 7 Worst Power BI Dashboard Mistakes & How to Avoid Them [PBIX examples included], Data Modeling with Power BI and Power Query, PowerBI M Language, PowerBI Best Practices, PowerBI Desktop, User and Developer, Visually appealing powerbi, PowerBI Trending

Пікірлер: 8
@katieo6802
@katieo6802
This was helpful thank you! How would you incorporate an OR clause such as: Count of orders > 500 OR SUM of order amount > 100,000?
@inderpanda
@inderpanda
2:52
@harbime
@harbime Жыл бұрын
Thanks, but you need to revise your method of educating people, since the understanding is minimum
@AbdallaAbdulrehman
@AbdallaAbdulrehman
i hardly understood what you was trying to do.. You need to go slower and show people what's going on exactly
@apaumichael954
@apaumichael954
you were too fast.. and it was difficult to understand
Understanding CALCULATE in DAX: Filters
18:01
BI Gorilla
Рет қаралды 17 М.
Using RELATED and RELATEDTABLE in DAX
18:04
SQLBI
Рет қаралды 37 М.
WHAT’S THAT?
00:27
Natan por Aí
Рет қаралды 13 МЛН
Зачем он туда залез?
00:25
Vlad Samokatchik
Рет қаралды 3,1 МЛН
ТАМАЕВ УНИЧТОЖИЛ CLS ВЕНГАЛБИ! Конфликт с Ахмедом?!
25:37
Эффект Карбонаро и нестандартная коробка
01:00
История одного вокалиста
Рет қаралды 9 МЛН
How to use Microsoft Power BI - Tutorial for Beginners
27:53
Kevin Stratvert
Рет қаралды 4 МЛН
How to Use the CALCULATE Function in Power BI
19:31
Nestor Adrianzen
Рет қаралды 58 М.
🚨 YOU'RE VISUALIZING YOUR DATA WRONG. And Here's Why...
17:11
Adam Finer - Learn BI Online
Рет қаралды 27 М.
How to use DAX in Power BI | Microsoft Power BI for Beginners
15:44
Alex The Analyst
Рет қаралды 175 М.
Understand VARIABLES and use them in DAX | Power BI
7:12
The Power BI Guy
Рет қаралды 5 М.
Power BI DAX Tutorial (2/50) - What is Measure or Calculated Column
13:57
Analytics with Nags
Рет қаралды 107 М.
How to Specify Multiple Filter Conditions in CALCULATE [Power BI]
18:03
Nestor Adrianzen
Рет қаралды 27 М.
How to create Power BI Dashboard (Report) in 7 Minutes | @PavanLalwani
12:55
WHAT’S THAT?
00:27
Natan por Aí
Рет қаралды 13 МЛН