CLICK HERE TO LEARN MORE ABOUT THE AWESOME COMPLETE POWER BI COURSE: https://lp.hashtagtreinamentos.com/es... TO DOWNLOAD THE FREE POWER BI MINI COURSE: http://bit.ly/2nQ3mvu Tutorial to install POWER BI for FREE: • Power BI Course - Lesson 0 - How to install... To receive daily Excel, VBA and Power BI content for free, join our Telegram group: https://t.me/joinchat/AAAAAFVJr0C7Il-... ----------------------------------------------------------------------- ► Spreadsheet used as a basis in the video: https://pages.hashtagtreinamentos.com... ----------------------------------------------------------------------- Hashtag Treinamentos ► Subscribe to our channel: https://bit.ly/2O6A4RP ► Turn on notifications (click on the bell)! ► Like our video! ----------------------------------------------------------------------- Social Networks ► YouTube: https://bit.ly/2O6A4RP ► Instagram: https://bit.ly/2F7B6t4 ► Facebook: https://bit.ly/2UA4SwY ► Telegram: https://t.me/joinchat/AAAAAFVJr0C7Il-... ----------------------------------------------------------------------- TOP Power BI Videos: ► Power BI Course - Class 01 - First steps in Power BI • Power BI Course - Class 01 - First ... ► Power BI Course - Class 02 - Manipulating Texts and Values ​​in the Database • Power BI Course - Class 02 - Manipulating ... ► Power BI Course - Class 03 - Creating a Billing Column and Column Chart • Power BI Course - Class 03 - Creating a ... ► Power BI Course - Lesson 04 - Donut and Bar Chart with Conditional Formatting • Power BI Course - Lesson 04 - Chart of... ► Power BI Course - Lesson 05 - Map Chart and Funnel Chart • Power BI Course - Lesson 05 - Chart of... ----------------------------------------------------------------------- In today's video we will learn how to calculate percentage in Power BI. To be able to do this, we will need to have knowledge about the ALL Power BI and Calculate Power BI formulas. For the ALL formula, this is the first time we have talked about it on the channel. As for the Calculate function, we have already talked about it in some other videos on the channel. There is no percentage function in Power BI. In Excel, for example, calculating this is relatively simple. In Power BI, this process is much less intuitive and requires a little more reasoning to arrive at the percentage of the overall Power BI total. To enter a percentage in Power BI, we will need to create a new measure. This measure will use the SUM formula to calculate the total number of orders. Once this is done, to continue our percentage of the total Power BI, we need to create another measure that will contain this percentage. This new measure will do the math of the previously calculated measure divided by the total (we would have to enter the value manually). Even though it works this way, calculating Power BI percentages this way is not the most efficient way. If any value were changed or added, this way would not work. To get a correct percentage of the overall Power BI total, we would need to filter our tables in an intelligent way. And, to do this, we will use the calculate and All formulas. ----------------------------------------------------------------------- #powerbi #hashtagtraining