DAX Fridays

Подписаться 135 тыс.

Просмотров 18 тыс.

50% 1

Do you wonder what is the difference between calculate and calculatetable dax fucntions? Then you are in the right place.
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
curbal.com/product/sponsor-me
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE

Опубликовано:

4 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 34

@rauljimenez5485 3 года назад

I use calculatetable to improve performance. E.g. To create a measure that counts how many clients there are in the group that accounts for 80% sales (Pareto Analysis) y could filter the client table and count the rows. The issue with that is that the filtered table still has all the columns of the client table, it is "heavier". Instead, I create a table with only the client ID column and apply a filter to that which returns only the clients that are in the group that accounts for 80% of sales, that is a "lighter", less expensive measure.

@abhishekstatus_7 3 года назад

Thanks for uploading this Ruth !! You are awesome!!

@deecammack1452 3 года назад

I'm very new with Power BI and this was helpful. :) Thank you!

@soumikmishra7288 3 года назад

Absolutely Wonderful!, Thanks Ruth

@zubairso 3 года назад

Always some insightful information, thanks!

@diegonoliveira 3 года назад

Amazing content... Thank you for share your knowledge !!!

@CurbalEN 3 года назад

My pleasure!

@kennethstephani692 3 года назад

Terrific, as always, Ruth!

@CurbalEN 3 года назад

🥳🥳

@suryasahoo3771 3 года назад

Excellent, Thanks for sharing Ruth 😊

@CurbalEN 3 года назад

🥳

@michaeloloishuro6915 3 года назад

Thanks the difference is clear.

@Henrik.Vestergaard 3 года назад

So great, you nail it again, thanks

@CurbalEN 3 года назад

Thanks Henrik!

@schipuu6669 3 года назад

Thank you sooooooo much! You helped me perfect by my actual problem! Now I defently understand the diffrent

@CurbalEN 3 года назад

🥳🥳🥳

@philipmathew6542 2 года назад

Nicely explained....thanks a ton.

@CurbalEN 2 года назад

🥳

@marcelocabral5096 2 года назад

Great vídeo tks ;)

@marksmith8021 Год назад

Hi Ruth, I'm trying to create a report that shows our Donors where their donations ended up. In our fact table the donation is recorded by Lot number, and then when we distribute it to food pantries it is on a different record with the Lot Number being the key between the two records. I can use a Calculate Table and filter based on the Selected Donor Id... but then I only want the distinct Lot numbers, that can be used in a measure to get the distribution side. Is this possible? Or is there a better way to do this?

@thomasivarsson2468 3 года назад

Bra genomgång som vanligt Rut och jag har lärt mig vad Queso Cabrales är. Ost från Austurias.

@CurbalEN 3 года назад

Enligt mitt pappa bästa osten i världen;)

@leandrocampolim3812 3 года назад

I love u.

@togetherpbi4506 3 года назад

Hi Ruth , I am unable to find the video where you guided us to import countries flags in Olympics dashboard. Can you please help with the link . Thanks Tej

@johngriffiths4636 3 года назад

Try ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-tZXY9RZwd3U.html&ab_channel=Curbal or look in curbal resources for the pbix.

@Su-ec7pj 3 года назад

Is there any performance difference between those two calculations that you demonstrated (one using CALCULATE & another using CALCULATETABLE)?

@CurbalEN 3 года назад

Performance depends on so many parameters that you need to check that with your model and data.

@brunof.s.8186 3 года назад

Excelent. What about FILTER and CALCULATETABLE? the difference is more subtle because both return tables. in the end, i almost use FILTER because is a-shorter and b-much more intuitive. Maybe a future video? :)

@CurbalEN 3 года назад

Definitely! :)

@user-wx3dn3il2f 3 года назад

wow i am always curious about filter and calculatetable, please deal with difference haha

@derekcech3893 3 года назад

Hi Ruth, I have an issue with my table. Sometimes our company has multiple sales within the same row because different products were sold. For example Deployment ID Product Name #1 Product Name # 2 Product Name #3 53 Apples Oranges Apples My issue is when I use a splicer for apples from product name #1, powerbi does not pick up the apples in product name #3 which makes our analysis wrong. I want to be able to have a solution that can pick up apples no matter what column they're in. Any help would be great :)

@CurbalEN 3 года назад

That is a perfect question to post in the power bi community. The solution is always hidden in the details, so make sure you post sample data.