This is very useful and well explained. I was inspired to create another measure Products bought = CONCATENATEX(RELATEDTABLE(Orders),Orders[Product],UNICHAR(10)) which is the kind of thing I want to use in reporting to have multiple text entries. Thanks for the video!
You can use something like the following. CONCATENATEX is also an iterator function: Products bought = CONCATENATEX(RELATEDTABLE(Orders),Orders[Product],UNICHAR(10))
Hi, for me the relatedtable is not working. When I added a column with a relatedtable function, I got the total sum of the expression in every row of that column. I am not sure what the mistake is, I did everything you did. Could you recognise this kind of error and help me ?
To be honest I dont use RELATED function all that often because a join already creates the relationship between the two tables. I can only assume they imported this function as a replacement for VLOOKUP in excel and is another way to achieve the same result
In my opinion these functions are completely useless in Power BI. You don't really need to add these vlookup columns because they're already connected and you can use them in any kind of visuals.
*CALCULATED COLUMNS* 2:27- RELATED 4:19- RELATEDTABLE 5:40- SUMX(RELATEDTABLE) *MEASURES* 6:30- SUM (if you don't need a column) (although this doesn't give row context until you put other fields in the table)
![SAFEPLANET - ดาวเคราะห์ [ THE PLANET ]](http://i.ytimg.com/vi/4X1XL3I_k3c/mqdefault.jpg)
Thank God. Someone finally explained this clearly. Thank you
You're welcome, thanks for watching!
This is very useful and well explained. I was inspired to create another measure
Products bought = CONCATENATEX(RELATEDTABLE(Orders),Orders[Product],UNICHAR(10))
which is the kind of thing I want to use in reporting to have multiple text entries. Thanks for the video!
I find this very useful and comprehensive. I would just also explain “why” you can use the relate only on the many table of the relationships.
Clear and concise explanations!
You really helped me in learning, thank you so much.
Great to hear! Thanks for watching!
I became fan of you by the way of your explanation .. sir... we need a live session to interact with you.. if its possible.
Thank you, appreciate your kind words! I'll think about it!
best explanation of related table on youtube. Thanks you sir
Really Nice and easy to understand through this video.
I'm glad it helped you Sumit!
Very nice explanation, kindly update more videos on DAX. Loved your explanation and content.
Great to hear that, thanks for watching Rakesh!
Excellent, thank you
You're welcome, thanks for watching!
Man you saved my night :)) !!
Good to hear that, thanks for watching!
good to understand!
Great video!
Glad you enjoyed it
really good job man.. thanks:)
EXCELLENT
thanks for the video. what if i want to bring text values using relatedtable in one relationship table ? sumx gives error.
You can use something like the following. CONCATENATEX is also an iterator function:
Products bought = CONCATENATEX(RELATEDTABLE(Orders),Orders[Product],UNICHAR(10))
Dear
How about if one dataset is connected using the direct query and from that table one names wanted to bring it to another table!
Hi, for me the relatedtable is not working. When I added a column with a relatedtable function, I got the total sum of the expression in every row of that column.
I am not sure what the mistake is, I did everything you did. Could you recognise this kind of error and help me ?
Hi there, perhaps its to do with the relationship you've set up? The column you create needs to be in the "Many" side of the relationship
Are you from Madagascar ? ^^
Hi there, I'm from the Philippines!
What if you're using Direct Query? These don't work with direct query.
Why do you need related when you already have a join?? Just grab the customer name from the customer table
To be honest I dont use RELATED function all that often because a join already creates the relationship between the two tables. I can only assume they imported this function as a replacement for VLOOKUP in excel and is another way to achieve the same result
I think you use it when the table is 2 or more relationships away. e.g.. sales
In my opinion these functions are completely useless in Power BI. You don't really need to add these vlookup columns because they're already connected and you can use them in any kind of visuals.
*CALCULATED COLUMNS*
2:27- RELATED
4:19- RELATEDTABLE
5:40- SUMX(RELATEDTABLE)
*MEASURES*
6:30- SUM (if you don't need a column) (although this doesn't give row context until you put other fields in the table)