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!

MY FAVOURITE POWER BI BOOKS

MY GEAR

GET IN TOUCH

🌍 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 YouTube.

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

🗺 Learn DAX to extend your Power BI calculations

📆 Stay up-to-date on all the features Power BI releases monthly

🧪 Get certified as a Microsoft Data Analyst Associate

💡 Learn Power BI Features to improve your dashboards

📊 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 #DataAnalytics #BusinessIntelligence

[ecoslitrarios]

Fernan, you are the best thing that has happened to me this year! 🎉 Thank you so much!

[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!

[ChrisSmithFW]

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

[salvi]

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

[PiyushKumar-tvdr]

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

[williamarthur]

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

[erinfield]

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.

[ameyraj]

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

[sameerkale]

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

[chaytanya]

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

[木淋叶]

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

[ashishmohan]

Hi

Hope you are doing fine.


very useful video and very practical need everyone for every project 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...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂

[cesarsaldana]

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