CALCULATE vs CALCULATETABLE / What's the difference? // Beginners Guide to Power BI in 2021

In this video I go through the main difference between the CALCULATE and CALCULATETABLE functions in Power BI. We go through a brief explanation, as well as a quick demo to explain it better.
-
🚩 Support us to get perks such as demo files, early access and more!
/ solutionsabroad
MY FAVOURITE POWER BI BOOKS
📕 The Definitive Guide to DAX - amzn.to/3ruYs2f
📗 DAX Patterns - amzn.to/3oVgOYs
MY GEAR
🎥 Canon 4000D DSLR Camera - amzn.to/3tCqDOw
💻 Cyberpower Wyvern PC - amzn.to/3q04QOw
🪑 Infamous Gaming Chair - amzn.to/3q3iUXw
💡 LED Studio Lighting - amzn.to/3q3ftQz
🎙 Lavalier Microphone - amzn.to/3jwKutG
📺 Monitor - amzn.to/2LuHhhO
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
📧 Email me - [e-mail]
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
📸 Instagram - / solutions_abroad
🐤 Twitter - / abroadsolutions
🤖 Reddit - / fernanespejo
🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of RUclips.
If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.
🐎 First, watch this video about how a typical Power BI workflow looks like
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.
🔻 Get started with Power BI Desktop for FREE
powerbi.microsoft.com/en-us/d...
#PowerBI #DataAnalytics #BusinessIntelligence

[@goldwhispers]

I have watched quite a few of your videos and just want to say that when i want to remind myself on a topic i rate your videos up there with some of the top expert youtube ones!

[@salvi2606]

You explained this well.. Thank you so much..

[@ChrisSmithFW]

Nicely done. Easy to understand. Thank you very much.

[@SolutionsAbroad]

Glad it was helpful!

[@williamarthur4801]

Thank you, that's all I wanted to know.

[@sameerkale7282]

Please make a video on an end to end project of DAX where important functions are used.

[@PiyushKumar-tv6dr]

Hi fernan!! Can I use COUNTROWS instead of COUNTX to achieve the same Objective?

[@EyiBillion]

Brilliant! Thanks

[@SolutionsAbroad]

You're welcome!

[@erinfield1943]

3:37- But what if you want that table to populate within the other table? Like I want those extra lines to appear in the table in which I'm writing the CALCULATETABLE function.

[@ameyraj4947]

Well explained. Thanks
One suggestion the background music keeps distracting from what you are explaining can you please exclude in your future videos when you start explaining.
Rest video is very informative & well explained

[@SolutionsAbroad]

a very big thanks for your feedback Amey, it really is much appreciated! I do have an issue with the music sometimes they are too loud and distracting, but at the same time I include them to fill in the white noise of my computer in the background. thanks for watching!

[@baneledludlu7983]

Great Vedios Fernan

[@chaytanya2293]

How CALCULATE function is different from COUNTX ? I can use filter context in COUNTX also.

[@user-oy3rt1rr4l]

how did you do it can you share with me , thank you

[@SolutionsAbroad]

If you need the file, you can find it here: ko-fi.com/s/026641aefa

[@ashishmohan4707]

Hi
Hope you are doing fine.
very useful video and very practical need everyone for every project ......very big thanks to share with us.
If it can possible can you plzz provide us excel data file which you used.
Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂

[@SolutionsAbroad]

Hi, you're very welcome, glad my videos help! I generated the sample data using an online website, mockaroo, but if you want to exact file that i used for this video, here's a download link ko-fi.com/s/026641aefa

[@cesarsaldana3429]

This is a rubbish example, I expected something more, because you are implying that it works like the FIlter function and it is not.