***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download FREE - Power BI Resources - enterprisedna.co/power-bi-resources Enterprise DNA Membership - enterprisedna.co/membership Enterprise DNA Online - www.enterprisedna.co/ Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/ ***** Related Links ***** Creating Virtual Relationships In Power BI Using The TREATAS Function - blog.enterprisedna.co/find-your-top-clients-across-different-measures-in-power-bi/ Using Power BI DAX Functions To Deal With Products That Have Changing Prices Overtime - blog.enterprisedna.co/how-to-deal-with-products-that-have-changing-prices-overtime-in-power-bi/ Compare Actual Results To Budgets Using Power BI Forecasting - blog.enterprisedna.co/compare-actual-results-to-budgets-or-forecasts-in-power-bi/ ***** Related Course Modules ***** DAX Formula Deep Dives - portal.enterprisedna.co/p/dax-formula-deep-dives Mastering DAX Calculations - portal.enterprisedna.co/p/mastering-dax-calculations Financial Reporting With Power BI - portal.enterprisedna.co/p/financial-reporting-power-bi ***** Related Support Forum Posts ***** TREATAS - Reconciling The Numbers - forum.enterprisedna.co/t/treatas-reconciling-the-numbers/2061 Budgeting Using TREATAS - forum.enterprisedna.co/t/budgeting-using-treatas/1610 Cumulative Total With A Measure Branched Measure That Utilizes TREATAS - forum.enterprisedna.co/t/cumulative-total-with-a-measure-branched-measure-that-utilises-treatas/4336 For more TREATAS support queries to review see here…. - forum.enterprisedna.co/search?q=treatas
Hi Paddle Shift, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Hi smgt90, glad that this video is of help! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials and announcements. Cheers!
I think I start to understand things more clearly. I think the way DAX works is that each time you make a connection between tables, DAX simply puts Treatas every time a measure needs to run a measure, and every measure is run as a row context on it's basic level, so treatas just makes context transition every time. That's why you get Treatas every time you run measures in DAX studio, even on simple visuals/Measures.
Sam, that is a truly smart function. Love it and very well explained, thank you. Does it need to be adjusted (added to) if you had an additional slicer and perhaps a chart on the same page that could interact with the table in example 2.
Yes you certainly need to be aware of other relationships and how they interact with calculations. I find keeping the model simple very crucial when using this function. You don't want any confusion.
This is very cool. Certainly have had a lot of scenarios where this could have been useful - will have to keep it in mind for future use. Especially like the combination of treatas and summarise. I wonder if you run into any of the same types of relational conflicts that you would with the real relationships?
This function actually allows you to get around most of those conflicts. It's actually very powerful for advanced modeling work (well you don't even need to model now as you can use the formula instead in a lot of cases
Amazing. I wish I was aware of it, or it existed, when I first started working with Power BI. Probably would have been a bit much to pick up back then - hopefully your video will help people starting out now.
Hii Sam, I've a question, I don't understand why Treatas function doesn't show result for 2015 Budget. Have you applied any type of filters or what happened?
In your example the Treatas result is empty on these rows (days) where there were no sales. How to avoid this and return the correct budget even if there were no sales on that particular day?
Hi, I tried to download the 60 Page DAX Reference Guide Download, but it just keeps taking me to the course. But I don't seem to be able to actually download the guide.
Hi Selina, thanks for posting your comment in the video. All pbix file/datasets are available for download in the Enterprise DNA Online, which is accessible via Membership. Find link below. Thanks! portal.enterprisedna.co/
Hello Yi Ling, thank you for posting your query onto our channel. Well, we cannot create a direct link or relationship between Year column from the Budget table with the Year column from the Dates table. This is because, the granularity is quite high and therefore it'll result in a "Many-to-Many" relationship which is absolutely not recommended at all in order to have an ideal and optimized data model. When we create a "Many-to-Many" relationships between the tables it might also provide some ambiguous and unfavorable results. Below is some of the links provided for the reference. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful. Also make sure that you're subscribed to our TH-cam channel so that you don't miss out on any updates pertaining to the Power BI. Happy Learning!!! forum.enterprisedna.co/ th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html th-cam.com/video/AlIvIlqKcB0/w-d-xo.html th-cam.com/video/JHFs6gFZhiE/w-d-xo.html th-cam.com/video/EocrvXatsd4/w-d-xo.html th-cam.com/video/dBSiClTGYKo/w-d-xo.html forum.enterprisedna.co/t/avoiding-a-many-to-many-relationship/12629 docs.microsoft.com/en-us/power-bi/guidance/relationships-many-to-many
Thanks a lot One question please related to the 2nd example , why you have selected Summarize ( 'Sales Data' , ......... ) and not Summarize ( Total Budget ..; ) Maybe my understanding is not correct
Hi Hüseyin Dalgıç, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download
FREE - Power BI Resources - enterprisedna.co/power-bi-resources
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Online - www.enterprisedna.co/
Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/
***** Related Links *****
Creating Virtual Relationships In Power BI Using The TREATAS Function - blog.enterprisedna.co/find-your-top-clients-across-different-measures-in-power-bi/
Using Power BI DAX Functions To Deal With Products That Have Changing Prices Overtime - blog.enterprisedna.co/how-to-deal-with-products-that-have-changing-prices-overtime-in-power-bi/
Compare Actual Results To Budgets Using Power BI Forecasting - blog.enterprisedna.co/compare-actual-results-to-budgets-or-forecasts-in-power-bi/
***** Related Course Modules *****
DAX Formula Deep Dives - portal.enterprisedna.co/p/dax-formula-deep-dives
Mastering DAX Calculations - portal.enterprisedna.co/p/mastering-dax-calculations
Financial Reporting With Power BI - portal.enterprisedna.co/p/financial-reporting-power-bi
***** Related Support Forum Posts *****
TREATAS - Reconciling The Numbers - forum.enterprisedna.co/t/treatas-reconciling-the-numbers/2061
Budgeting Using TREATAS - forum.enterprisedna.co/t/budgeting-using-treatas/1610
Cumulative Total With A Measure Branched Measure That Utilizes TREATAS - forum.enterprisedna.co/t/cumulative-total-with-a-measure-branched-measure-that-utilises-treatas/4336
For more TREATAS support queries to review see here…. - forum.enterprisedna.co/search?q=treatas
You just saved my life. I couldn't understand why TREATAS was not working. Your strategy using summarize worked. Thanks.
Sam, I am currently working through this and, it is going VERY well!!! You are a gift to the POWER BI/Data Modeling Community.
Hi Mark, great thanks. Yes this is another idea for your budgeting question on the forum. This is another way you can solve that.
Excellent solution to nest SUMMARIZE and TREATAS functions! Many thanks for the very helpful tip. If I may, continue to make videos like this.
That's exactly what I was looking for. Great video as always!
Thank you for great explanation. As I understand this function allows to join/compare two fact tables that are on different granularities.
Awesome!! Thank you so much!! Please keep them coming!! 👍👍
Nice! Finally an SMR DAX training course! Didn't know TREATAS was used to generate HUH? output!
Hi Paddle Shift, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials.
Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Thanks, very helpful!
Hi smgt90, glad that this video is of help! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials and announcements. Cheers!
@@EnterpriseDNA subscribed!
I think I start to understand things more clearly.
I think the way DAX works is that each time you make a connection between tables, DAX simply puts Treatas every time a measure needs to run a measure, and every measure is run as a row context on it's basic level, so treatas just makes context transition every time.
That's why you get Treatas every time you run measures in DAX studio, even on simple visuals/Measures.
Sam, that is a truly smart function. Love it and very well explained, thank you. Does it need to be adjusted (added to) if you had an additional slicer and perhaps a chart on the same page that could interact with the table in example 2.
Yes you certainly need to be aware of other relationships and how they interact with calculations. I find keeping the model simple very crucial when using this function. You don't want any confusion.
This is very cool. Certainly have had a lot of scenarios where this could have been useful - will have to keep it in mind for future use. Especially like the combination of treatas and summarise. I wonder if you run into any of the same types of relational conflicts that you would with the real relationships?
This function actually allows you to get around most of those conflicts. It's actually very powerful for advanced modeling work (well you don't even need to model now as you can use the formula instead in a lot of cases
Amazing. I wish I was aware of it, or it existed, when I first started working with Power BI. Probably would have been a bit much to pick up back then - hopefully your video will help people starting out now.
Hii Sam,
I've a question, I don't understand why Treatas function doesn't show result for 2015 Budget.
Have you applied any type of filters or what happened?
Thanks... That was useful..
thanks , very useful and helpful function. need some dax table function exemple like groupby
I think 'SUMMARIZE' function will be useful for you.
In your example the Treatas result is empty on these rows (days) where there were no sales. How to avoid this and return the correct budget even if there were no sales on that particular day?
This is also what I need to do
Hi,
Thanks for this great tutorial. Can you share this data?
How do you add in crossfilter = both functionality in the treatas virtual relationship situation?
Hi Chris, see here for some ideas on this - forum.enterprisedna.co/search?q=treatas%20virtual%20relationship%20Crossfilter
Hi, I tried to download the 60 Page DAX Reference Guide Download, but it just keeps taking me to the course. But I don't seem to be able to actually download the guide.
Hi Selina, thanks for posting your comment in the video. All pbix file/datasets are available for download in the Enterprise DNA Online, which is accessible via Membership. Find link below. Thanks!
portal.enterprisedna.co/
Thank you
Where is it possible to download Example Files for this video?? OMG... So many links, but none the .pbix file...
Hi, .pbix file is available in the Enterprise DNA Online which is accessible via membership
Why don't you just directly link to the lookup Date table?
Hello Yi Ling,
thank you for posting your query onto our channel.
Well, we cannot create a direct link or relationship between Year column from the Budget table with the Year column from the Dates table. This is because, the granularity is quite high and therefore it'll result in a "Many-to-Many" relationship which is absolutely not recommended at all in order to have an ideal and optimized data model. When we create a "Many-to-Many" relationships between the tables it might also provide some ambiguous and unfavorable results. Below is some of the links provided for the reference.
For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
Hoping you find this useful.
Also make sure that you're subscribed to our TH-cam channel so that you don't miss out on any updates pertaining to the Power BI.
Happy Learning!!!
forum.enterprisedna.co/
th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
th-cam.com/video/AlIvIlqKcB0/w-d-xo.html
th-cam.com/video/JHFs6gFZhiE/w-d-xo.html
th-cam.com/video/EocrvXatsd4/w-d-xo.html
th-cam.com/video/dBSiClTGYKo/w-d-xo.html
forum.enterprisedna.co/t/avoiding-a-many-to-many-relationship/12629
docs.microsoft.com/en-us/power-bi/guidance/relationships-many-to-many
Thanks a lot
One question please related to the 2nd example , why you have selected Summarize ( 'Sales Data' , ......... ) and not Summarize ( Total Budget ..; )
Maybe my understanding is not correct
Because that's the order you want them to be placed into within the TREATAS function
Sweetas
I thought you said Same Guy :)
Hi Hüseyin Dalgıç, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials.
Here’s the link:
th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html