Related and RelatedTable in DAX

[@daveybalmer]

A perfect explanation delivered crisply with no embroidery or annoying background music. Thanks

[@DrK99999]

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.

[@davidignatius1]

Your note at the beginning of the video is extremely powerful since many other videos do not explain that. Keep up the good work!

[@GoodlyChandeep]

Glad you liked it David!

[@BusinessQuant]

One year on, and the tutorial is still immensely helpful! Just referred to it again for another round of development. Thanks again!

[@GoodlyChandeep]

Glad it helped!

[@RaviGupta-mo1nf]

Great explanation Great English Therefore perfect clarity. I will keep watching all your videos to learn!!

[@emilyamalkin4367]

I love how you explain the topic - I get it! Thank you and please keep them coming, you are a talented teacher! ❤

[@fabiocardososantos5677]

By far, the best explanation i got about this topic in KZbin. Very nice job.

[@Albert-zf8ct]

easy peasy, clear and simple explanation - well done - thank you!

[@hairavyadav6579]

Really thanks for this video best video to understand this concept ... I watch many video but really by this video i can understand now

[@ImranHussain-xv4se]

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.

[@GoodlyChandeep]

Thanks.. Keep watching

[@DavidPetersen-s1s]

Thanks for this, finally I get it. Will make my life alot easier by not writing complicated lookups

[@abhishekpacheriwala496]

Simple example with good clarity. Exactly what i was looking for.

[@GoodlyChandeep]

Hey Glad you found it helpful!

[@jaipalcse]

What a logical explanation straight fit into my brain.

[@harishpaldhir5915]

SIR AN EYE OPENING VIDEO ON RELATED AND RELATEDTABLE VERY GOOD EFFORT SIR TO TEACH DUMMIES LIKE US GOOD ONE

[@Victor-zo7dp]

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

[@ricardogoncalves9204]

THANK YOU!!!!! This saved me lots of time and more importantly saved my nerves :) Cheers

[@Tessie1993]

Thanks so much, that helped me a bunch!! Was going completely crazy haha

[@pulapanamgama3482]

Perfectly explained. Thank you so much!

[@GoodlyChandeep]

Glad you like this Pula!

[@翁孤舟]

You are an excellent teacher and speaker.

[@GoodlyChandeep]

Thank you so much

[@shwetadalal389]

thanks for clearing all my doubts with this video!

[@ruhiscorner7318]

Just one word-Amazing!

[@ajinkyashinde1778]

as always crystal clear explanation.🔥

[@Laxmanmane007]

Really awesome also make vdo on summarize the and summarize columns to clearly understand exact diff.🙂

[@ibejoseph19]

GREAT EXPLANATION! I WAS ALREADY LOSING HOPE 😂♥️. Thank youuuuu

[@GoodlyChandeep]

Glad you like it!

[@vishaljhaveri7565]

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) : kzbin.info/www/bejne/q4O6dYaOe5d1q9U 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".

[@ajaykumarvelivela9472]

Crystal clear bro.Thanks for the video

[@BusinessQuant]

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?

[@GoodlyChandeep]

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.

[@pranjalagrawal4167]

I believe, wherever in measure it's asking for a table we can give RELATEDTABLE.

[@Usr-vpo-p]

Thanks helped me crack an interview in one day :D

[@mahathmasadineni2884]

Hi Chandeep, Great explanation could you please do a vedio on what will happen if refer to price column with out using RELATED Function.

[@sangeethetikala]

Excellent Very Detailed Explanation, looking forward for more videos.

[@GoodlyChandeep]

More to come! :)

[@norpriest521]

@@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.

[@aryansena7290]

Great explanation, just b little slow for beginners. Thanks a lot.. Need more video

[@GoodlyChandeep]

More to come!

[@kaleeswarichellamani5185]

Great and clear Explanation.Thanks. plse share this practice file.

[@surojeetdey57]

Sir, Whatever you did in the related table function in new column, can we do this new measure by using iterator function.

[@avinashnl9588]

Superb explanation, Loved it. Keep the good work.

[@ketankale4223]

Really very good and simple explanation

[@GoodlyChandeep]

Thank you!

[@saurabh-sharma]

Mistake at 2:54, {Not a many side of the relation instead that is one side of the relationship}. Overall great content brother.

[@ramonillarramendi3191]

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?

[@GoodlyChandeep]

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

[@ranjanajoshi3099]

Awesome explanation!!

[@ezazhaider3466]

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.

[@mayurkanth6987]

2:51 How is this many side of the relation? Shouldnt it be 1 ?

[@animoki9292]

Nice bro..well done..keep doing the good work..God bless you

[@bloom6874]

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.

[@SiamData]

as always great explaination!

[@shoaibrehman9988]

Very good explanation thanks

[@jonatorba]

Excellent explanation!

[@stephencross4978]

thanks Chandeep, a great video and so nicely explained!

[@peterhaftner9477]

Well explanation, thank you!

[@GoodlyChandeep]

Glad you enjoyed it!

[@hariprasad289]

Wonderful explanation, thank you

[@GoodlyChandeep]

Glad you like it 😊

[@perrybundoc6714]

great explanation. thanks.

[@zerobars3]

Great tutorial, very well explained.

[@TheGreatAzhar]

Very Nice Explaination

[@mahimasharma2111]

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.

[@stephenbrincat7124]

Thanks very well explained

[@califa31]

VERY WELL EXPLAINED

[@GoodlyChandeep]

Glad you think so!

[@sujit3375]

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

[@ALBERTYY55]

clear explanation. thanks.

[@sujit3375]

What if i need data from one fact table into other fact table via usinh measure

[@dhananjaykulkarni5445]

Nice explanation

[@Everyonelovesyou]

Really informative.

[@javedhassansheik903]

can you provide the datasets so we can practice in power bi

[@nehaupes]

Nice explanation.

[@GoodlyChandeep]

Thanks!

[@GauravSharma-iu5mr]

Well Explained

[@redboom9874]

Is this functions work with direct query.

[@summaoruvideo7300]

at 2.52 instead of one side you mentioned many side of the relationship😎

[@3danim8r1]

Nicely explained....

[@seynabouba779]

Excellent !

[@GoodlyChandeep]

Glad you like it!

[@anuragbawankar685]

Thank you !

[@sandeepjami9119]

Thanks, Mate

[@pravinshingadia7337]

Can we please have the file you show in each video as a downloadable so we can practice with you?

[@GoodlyChandeep]

Try to include it in all videos.. but could've missed out for this video :|

[@reenamonteirosonar4607]

i think u made a mistake in the video @2.52 u called the product table as the many side of the relationship ?

[@rahulshewale9206]

Thank you sir

[@pranjalagrawal4167]

Excellent

[@stevennye5075]

very useful!

[@ArifulIslam-gs6uy]

Fantastic

[@arunv1909]

2:54 its the one side

[@abhishek12865a]

thanks bro

[@viveklk21]

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.

[@venkatareddykummitha5863]

give the excel doc. please

[@Tat-cx1lr]

Speak slowly please ☹️☹️☹️☹️

[@Wzxxx]

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😵‍💫

[@dareemmanuel6079]

Excellent explanation!