DAX Fridays #186: CALCULATE vs CALCULATETABLE

Do you wonder what is the difference between calculate and calculatetable dax fucntions? Then you are in the right place.


SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

▼▼▼▼▼▼▼▼▼▼

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:


Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲


************





************


QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#CURBAL #SUBSCRIBE

[rauljimenez]

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.

[veeek]

this is cool, didn't realise you could make tables in dax.

[abhishekstatus_]

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

[marksmith]

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?

[deecammack]

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

[togetherpbi]

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

[Su-ecpj]

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

[diegonoliveira]

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

[schipuu]

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

[zubairso]

Always some insightful information, thanks!

[derekcech]

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 :)

[brunof.s.]

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? :)

[thomasivarsson]

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