Related and RelatedTable in DAX

Learn how to work with the RELATED and RELATEDTABLE function in DAX
Learn SUMX - • SUMX Function in DAX
- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
- - - - Blog - - - -
www.goodly.co.in/blog

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

[@RaviGupta-mo1nf]

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

[@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!

[@ricardogoncalves9204]

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

[@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!

[@emilyamalkin4367]

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

[@Tessie1993]

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

[@abhishekpacheriwala496]

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

[@GoodlyChandeep]

Hey Glad you found it helpful!

[@shwetadalal389]

thanks for clearing all my doubts with this video!

[@user-kv2bn5ip3q]

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

[@ajaykumarvelivela9472]

Crystal clear bro.Thanks for the video

[@ajinkyashinde1778]

as always crystal clear explanation.🔥

[@ProductPro_Insights]

Thanks helped me crack an interview in one day :D

[@jaipalcse]

What a logical explanation straight fit into my brain.

[@dareemmanuel6079]

Excellent explanation!

[@zerobars3]

Great tutorial, very well explained.

[@stephencross4978]

thanks Chandeep, a great video and so nicely explained!

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

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

[@avinashnl9588]

Superb explanation, Loved it. Keep the good work.

[@harishpaldhir5915]

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

[@stephenbrincat7124]

Thanks very well explained

[@kaleeswarichellamani5185]

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

[@pulapanamgama3482]

Perfectly explained. Thank you so much!

[@GoodlyChandeep]

Glad you like this Pula!

[@ranjanajoshi3099]

Awesome explanation!!

[@ALBERTYY55]

clear explanation. thanks.

[@Laxmanmane007]

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

[@shoaibrehman9988]

Very good explanation thanks

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

[@perrybundoc6714]

great explanation. thanks.

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

[@user-pw7mp7sz6n]

You are an excellent teacher and speaker.

[@GoodlyChandeep]

Thank you so much

[@anuragbawankar685]

Thank you !

[@peterhaftner9477]

Well explanation, thank you!

[@GoodlyChandeep]

Glad you enjoyed it!

[@Everyonelovesyou]

Really informative.

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

[@animoki9292]

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

[@ibejoseph19]

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

[@GoodlyChandeep]

Glad you like it!

[@sandeepjami9119]

Thanks, Mate

[@TheGreatAzhar]

Very Nice Explaination

[@3danim8r1]

Nicely explained....

[@ketankale4223]

Really very good and simple explanation

[@GoodlyChandeep]

Thank you!

[@rahulshewale9206]

Thank you sir

[@stevennye5075]

very useful!

[@hariprasad289]

Wonderful explanation, thank you

[@GoodlyChandeep]

Glad you like it 😊

[@califa31]

VERY WELL EXPLAINED

[@GoodlyChandeep]

Glad you think so!

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

[@GauravSharma-iu5mr]

Well Explained

[@aryansena7290]

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

[@GoodlyChandeep]

More to come!

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

[@dhananjaykulkarni5445]

Nice explanation

[@seynabouba779]

Excellent !

[@GoodlyChandeep]

Glad you like it!

[@surojeetdey57]

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

[@pranjalagrawal4167]

Excellent

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

[@summaoruvideo7300]

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

[@abhishek12865a]

thanks bro

[@ArifulIslam-gs6uy]

Fantastic

[@nehaupes]

Nice explanation.

[@GoodlyChandeep]

Thanks!

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

[@sujit3375]

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

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

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

[@javedhassansheik903]

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

[@redboom9874]

Is this functions work with direct query.

[@arunv1909]

2:54 its the one side

[@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 :|

[@venkatareddykummitha5863]

give the excel doc. please

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

[@Tat-cx1lr]

Speak slowly please ☹️☹️☹️☹️

[@jonatorba]

Excellent explanation!