DAX Concepts: How to Create Best in Category Calculations with Ease
In this video, you'll learn the insider secrets to calculating best in category rankings like a pro using DAX. Whether you're a business analyst, data scientist, or just someone who loves working with data, this tutorial will give you the tools you need to take your analysis to the next level.
We are going to learn how to use MAXX and ALLSELECTED to calculate the maximum or best in a category and use conditional formatting to highlight the value in the visuals.
You are also going to learn how to use sneaky field format option to colour the graph thru DAX 😲
⏱ In this video:
=============
0:00 - Best in category with DAX - a demo of the solution
1:20 - Creating a small-multiple graph in Power BI
2:26 - Generating the Best in Category DAX
5:17 - DAX for colouring the graph based on best in category.
7:16 - Applying conditional formatting rules
📂 Practice Workbook
===================
You can apply this concept with any of your datasets. Here is a sample dataset for you try -
https://chandoo.org/wp/wp-content/uploads/2022/09/sample-data-10mins.xlsx
Master DAX - My Videos on the topic 👩💻
================================
Beginner to PRO DAX video - https://youtu.be/PQ5lALdFHCU
Difference between New Measure and New Column, This is important - https://youtu.be/kgNbWOCuRCE
Different calculation for Subtotal with DAX - https://youtu.be/n7gAJMBdJ8k
My Power Pivot Playlist - https://www.youtube.com/watch?v=n7gAJMBdJ8k&list=PLmejDGrsgFyCm0i58VobdriBr--FA8lYh
Full Power BI Course - https://chandoo.org/wp/power-bi-course/
~
#powerbi
Видео DAX Concepts: How to Create Best in Category Calculations with Ease канала Chandoo
We are going to learn how to use MAXX and ALLSELECTED to calculate the maximum or best in a category and use conditional formatting to highlight the value in the visuals.
You are also going to learn how to use sneaky field format option to colour the graph thru DAX 😲
⏱ In this video:
=============
0:00 - Best in category with DAX - a demo of the solution
1:20 - Creating a small-multiple graph in Power BI
2:26 - Generating the Best in Category DAX
5:17 - DAX for colouring the graph based on best in category.
7:16 - Applying conditional formatting rules
📂 Practice Workbook
===================
You can apply this concept with any of your datasets. Here is a sample dataset for you try -
https://chandoo.org/wp/wp-content/uploads/2022/09/sample-data-10mins.xlsx
Master DAX - My Videos on the topic 👩💻
================================
Beginner to PRO DAX video - https://youtu.be/PQ5lALdFHCU
Difference between New Measure and New Column, This is important - https://youtu.be/kgNbWOCuRCE
Different calculation for Subtotal with DAX - https://youtu.be/n7gAJMBdJ8k
My Power Pivot Playlist - https://www.youtube.com/watch?v=n7gAJMBdJ8k&list=PLmejDGrsgFyCm0i58VobdriBr--FA8lYh
Full Power BI Course - https://chandoo.org/wp/power-bi-course/
~
#powerbi
Видео DAX Concepts: How to Create Best in Category Calculations with Ease канала Chandoo
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![4 Essential Excel Skills Every Entrepreneur Needs 💼](https://i.ytimg.com/vi/WCuqPcvmLPo/default.jpg)
![Create One Pivot Table from Many Sheets ~ AWESOME Excel Trick](https://i.ytimg.com/vi/gi-DSWEUC-A/default.jpg)
![TOP 10 XL Functions #excel](https://i.ytimg.com/vi/vQIgNQ6UfFM/default.jpg)
![Example Data Analyst Interview Question - Can you solve this? 🤔](https://i.ytimg.com/vi/cMEvyhvd5Es/default.jpg)
![I don't use PIVOT tables anymore... I use this other thing instead!](https://i.ytimg.com/vi/SPFQX82X03Q/default.jpg)
![Excel Magic Revealed: Unstacking Data Like a Pro! ✨](https://i.ytimg.com/vi/fOokEIZlh8I/default.jpg)
![What is Microsoft Fabric & what can we DO with it?](https://i.ytimg.com/vi/--cK4A2djoA/default.jpg)
![Power BI Q&A - What is Microsoft Fabric? Tableau vs. Power BI, How important is SQL and more...](https://i.ytimg.com/vi/fOyvqXxADvE/default.jpg)
![How to make a Map Chart in Excel - Quick & Simple Tutorial](https://i.ytimg.com/vi/qNNn5uiZxOE/default.jpg)
![ONLY Excel pros use this INDEX MATCH trick 💡](https://i.ytimg.com/vi/v4RnVh2iGgU/default.jpg)
![How to make an Interactive & Beautiful Excel Dashboard in 5 Steps](https://i.ytimg.com/vi/35VnP0Rz71I/default.jpg)
![I got braces in my 40s!](https://i.ytimg.com/vi/3uNjbewTGGw/default.jpg)
![6 *proven* strategies I used to make $100,000+ with my Excel Skills](https://i.ytimg.com/vi/USU2AzGWu_Q/default.jpg)
![Honey, I shrunk the lengthy Excel formula (by 80%😮)](https://i.ytimg.com/vi/HCEIzeIdiD0/default.jpg)
![FREE Power Query Materclass with 5 Advanced Tips to SPEED UP your work 🚀](https://i.ytimg.com/vi/yJum0g4qM2c/default.jpg)
![How to use TEXTSPLIT() in Excel](https://i.ytimg.com/vi/SI2YbN3CY5s/default.jpg)
![Make a beautiful and interactive To-Do List with Excel (Easy Tutorial 👌)](https://i.ytimg.com/vi/mA93MQgKRTc/default.jpg)
![Email Excel Reports with Power Automate & Office Scrips - One Click Automation 🤖](https://i.ytimg.com/vi/eeCqaokSSoQ/default.jpg)
![Power BI got a MAJOR upgrade - This changes everything!](https://i.ytimg.com/vi/5LhYxgtBToQ/default.jpg)
![Learn Tableau in 15 minutes and create your first report (FREE Sample Files)](https://i.ytimg.com/vi/tNLp_JVipoQ/default.jpg)