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.
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?
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
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 :)
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? :)
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.
Nicely explained....thanks a ton.
🥳
Wooooooah this is cool, didn't realise you could make tables in dax.
It is!! A lot of dax functions create tables :)
Thanks for uploading this Ruth !! You are awesome!!
Excellent, Thanks for sharing Ruth 😊
🥳
I'm very new with Power BI and this was helpful. :) Thank you!
Absolutely Wonderful!, Thanks Ruth
Amazing content... Thank you for share your knowledge !!!
My pleasure!
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?
Terrific, as always, Ruth!
🥳🥳
Thank you sooooooo much! You helped me perfect by my actual problem! Now I defently understand the diffrent
🥳🥳🥳
Bra genomgång som vanligt Rut och jag har lärt mig vad Queso Cabrales är. Ost från Austurias.
Enligt mitt pappa bästa osten i världen;)
Thanks the difference is clear.
Is there any performance difference between those two calculations that you demonstrated (one using CALCULATE & another using CALCULATETABLE)?
Performance depends on so many parameters that you need to check that with your model and data.
So great, you nail it again, thanks
Thanks Henrik!
Always some insightful information, thanks!
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
Try ua-cam.com/video/tZXY9RZwd3U/v-deo.html&ab_channel=Curbal or look in curbal resources for the pbix.
Great vídeo tks ;)
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 :)
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.
Could you do gross profit margins
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? :)
Definitely! :)
wow i am always curious about filter and calculatetable, please deal with difference haha
I love u.
👍