This video explained the logic behind using another dax with relatedtable. Related table used in sylos doesn't yield anything, that's where the way the video portion for relatedtable from 5:15 to 7:15 is described is awesome. One of the best video for relatedtable. Thanks, Chandeep.
thank you for a very clear explanation. what function i will use in picking up the string from one table to another like name of country name to put in another table
Nice video. If you don't understand this function at first go, 1. Follow this video first. This is the VLookup in Excel(in Hindi) : ua-cam.com/video/uRWDSXF2Bus/v-deo.html 2. Continue with this video. Thank you so much for this video. Finally understood these functions. PS : At 2:51, it would be "one side" instead of "many side".
@@GoodlyChandeep Hi, I would like to ask if I have..... [Fact table] Scan_id (surrogate key) and [Dim table] Scan_id (foreign key) Medicine_id (foreign key) I want to throw Medicine_id into the fact table. Is there any way I can do it? Because Scan_id is the only key those two tables can connect with each other. Can I somehow use RELATED or RELATEDTABLE for this particular scenario? I mean I don't want to do aggregation, I just wanted to do similar thing like RELATED. I only want it to show values. Appreciate your answer.
but the ms learn document says, it works on many to one relationship. Could you please confirm as I am getting confused now. Somewhere I read it is used for both one to many and many to one.
Great. Thank you very much. Excellent explanation. Would it be better to have the column i.e total sales included in power query via a merge of tables? In measures, do you always have to use the related function or would the calculation be alright due to the existing relation that exists between the two tables?
Refrain from merging tables. Using Relationship is a much better way to go. Also the RELATED function only gets triggered when you use the total sales measure
Thank you so much, was trying to understand this problem from the last 3 hours. Perfect explanation! One thing though, is there anything else apart from COUNTROWS that works on RELATEDTABLE?
Thanks Piyush, I am glad you liked how I explain ;) You can do anything with the table collected using RELATEDTABLE. for example creating a column with the formula =SUMX ( REALTEDTABLE ( Sales ), Sales [Units] ) will give you a column with total units for each product in the sales table.
What if i want to fetch column from one fact table into another fact table Using measure ( not able to fetch) But by using new column i am able to fetch that
Hi Goodly, for related table you mention relationship build on many to one etc. , but I guess it is one to many, and in example you show one to many but in beginning of video you mentioned many to one etc.
What is the difference between "COUNTROWS(Table1)" and "COUNTROWS(RELATEDTABLE(Table1))"? Here "Table1" is Fact Table and I used this formula on dimention table but both are giving different values. Counld you plz explain. I used this formula in calculated column.
2.48 to 2.53 ..an error in explanation of related function....ie It not guving the intellisense because its on the one side of the relationship...You just said many side.
Hmmm…it seems that and relatedtable gives similar results as a filtercontext in calculated colums even if we use a row context. It is so frustrating as in a dax bible is always mentioned that rowcontext iterates and doeas not filter😵💫
A perfect explanation delivered crisply with no embroidery or annoying background music. Thanks
This video explained the logic behind using another dax with relatedtable. Related table used in sylos doesn't yield anything, that's where the way the video portion for relatedtable from 5:15 to 7:15 is described is awesome. One of the best video for relatedtable. Thanks, Chandeep.
One year on, and the tutorial is still immensely helpful!
Just referred to it again for another round of development.
Thanks again!
Glad it helped!
Great explanation
Great English
Therefore perfect clarity.
I will keep watching all your videos to learn!!
Your note at the beginning of the video is extremely powerful since many other videos do not explain that. Keep up the good work!
Glad you liked it David!
I love how you explain the topic - I get it! Thank you and please keep them coming, you are a talented teacher! ❤
easy peasy, clear and simple explanation - well done - thank you!
By far, the best explanation i got about this topic in UA-cam. Very nice job.
Simple example with good clarity. Exactly what i was looking for.
Hey Glad you found it helpful!
What a logical explanation straight fit into my brain.
Thanks so much, that helped me a bunch!! Was going completely crazy haha
Thanks sir, I have gone through many videos on this topic but the way you have explained is marvelous. Looking forward to more such videos.
Thanks.. Keep watching
Thanks for this, finally I get it. Will make my life alot easier by not writing complicated lookups
Really thanks for this video best video to understand this concept ... I watch many video but really by this video i can understand now
Just one word-Amazing!
as always crystal clear explanation.🔥
THANK YOU!!!!! This saved me lots of time and more importantly saved my nerves :) Cheers
thanks for clearing all my doubts with this video!
Crystal clear bro.Thanks for the video
Perfectly explained. Thank you so much!
Glad you like this Pula!
You are an excellent teacher and speaker.
Thank you so much
Awesome explanation!!
SIR AN EYE OPENING VIDEO ON RELATED AND RELATEDTABLE
VERY GOOD EFFORT SIR TO TEACH DUMMIES LIKE US
GOOD ONE
thank you for a very clear explanation. what function i will use in picking up the string from one table to another like name of country name to put in another table
Excellent explanation!
Nice video. If you don't understand this function at first go,
1. Follow this video first. This is the VLookup in Excel(in Hindi) : ua-cam.com/video/uRWDSXF2Bus/v-deo.html
2. Continue with this video.
Thank you so much for this video. Finally understood these functions.
PS : At 2:51, it would be "one side" instead of "many side".
Really awesome also make vdo on summarize the and summarize columns to clearly understand exact diff.🙂
great explanation. thanks.
as always great explaination!
GREAT EXPLANATION! I WAS ALREADY LOSING HOPE 😂♥️. Thank youuuuu
Glad you like it!
Thanks very well explained
Superb explanation, Loved it. Keep the good work.
Excellent Very Detailed Explanation, looking forward for more videos.
More to come! :)
@@GoodlyChandeep
Hi,
I would like to ask if I have.....
[Fact table]
Scan_id (surrogate key)
and
[Dim table]
Scan_id (foreign key)
Medicine_id (foreign key)
I want to throw Medicine_id into the fact table.
Is there any way I can do it?
Because Scan_id is the only key those two tables can connect with each other.
Can I somehow use RELATED or RELATEDTABLE for this particular scenario?
I mean I don't want to do aggregation, I just wanted to do similar thing like RELATED. I only want it to show values.
Appreciate your answer.
thanks Chandeep, a great video and so nicely explained!
Really very good and simple explanation
Thank you!
Thanks helped me crack an interview in one day :D
Great tutorial, very well explained.
Well explanation, thank you!
Glad you enjoyed it!
2:51 How is this many side of the relation?
Shouldnt it be 1 ?
Nice bro..well done..keep doing the good work..God bless you
Very good explanation thanks
Very Nice Explaination
Wonderful explanation, thank you
Glad you like it 😊
Sir, Whatever you did in the related table function in new column, can we do this new measure by using iterator function.
clear explanation. thanks.
but the ms learn document says, it works on many to one relationship. Could you please confirm as I am getting confused now. Somewhere I read it is used for both one to many and many to one.
Great explanation, just b little slow for beginners. Thanks a lot.. Need more video
More to come!
VERY WELL EXPLAINED
Glad you think so!
Really informative.
Great and clear Explanation.Thanks. plse share this practice file.
Thank you !
Well Explained
Nice explanation
Thanks, Mate
Nicely explained....
Nice explanation.
Thanks!
can you provide the datasets so we can practice in power bi
Great. Thank you very much. Excellent explanation. Would it be better to have the column i.e total sales included in power query via a merge of tables?
In measures, do you always have to use the related function or would the calculation be alright due to the existing relation that exists between the two tables?
Refrain from merging tables.
Using Relationship is a much better way to go.
Also the RELATED function only gets triggered when you use the total sales measure
Thank you so much, was trying to understand this problem from the last 3 hours. Perfect explanation!
One thing though, is there anything else apart from COUNTROWS that works on RELATEDTABLE?
Thanks Piyush, I am glad you liked how I explain ;)
You can do anything with the table collected using RELATEDTABLE.
for example creating a column with the formula =SUMX ( REALTEDTABLE ( Sales ), Sales [Units] )
will give you a column with total units for each product in the sales table.
I believe, wherever in measure it's asking for a table we can give RELATEDTABLE.
Is this functions work with direct query.
Excellent !
Glad you like it!
Hi Chandeep, Great explanation could you please do a vedio on what will happen if refer to price column with out using RELATED Function.
Thank you sir
What if i need data from one fact table into other fact table via usinh measure
Mistake at 2:54, {Not a many side of the relation instead that is one side of the relationship}.
Overall great content brother.
What if i want to fetch column from one fact table into another fact table
Using measure ( not able to fetch)
But by using new column i am able to fetch that
Excellent
Hi Goodly, for related table you mention relationship build on many to one etc.
, but I guess it is one to many, and in example you show one to many but in beginning of video you mentioned many to one etc.
very useful!
What is the difference between "COUNTROWS(Table1)" and "COUNTROWS(RELATEDTABLE(Table1))"? Here "Table1" is Fact Table and I used this formula on dimention table but both are giving different values. Counld you plz explain. I used this formula in calculated column.
Fantastic
thanks bro
Can we please have the file you show in each video as a downloadable so we can practice with you?
Try to include it in all videos.. but could've missed out for this video :|
at 2.52 instead of one side you mentioned many side of the relationship😎
i think u made a mistake in the video @2.52 u called the product table as the many side of the relationship ?
2:54 its the one side
give the excel doc. please
2.48 to 2.53 ..an error in explanation of related function....ie It not guving the intellisense because its on the one side of the relationship...You just said many side.
Speak slowly please ☹️☹️☹️☹️
Hmmm…it seems that and relatedtable gives similar results as a filtercontext in calculated colums even if we use a row context.
It is so frustrating as in a dax bible is always mentioned that rowcontext iterates and doeas not filter😵💫
Excellent explanation!