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)
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.
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!
Clear and concise explanations!
You really helped me in learning, thank you so much.
Great to hear! Thanks for watching!
best explanation of related table on youtube. Thanks you sir
Thank you 🎉
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!
Man you saved my night :)) !!
Good to hear that, thanks for watching!
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!
Excellent, thank you
You're welcome, thanks for watching!
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))
Great video!
Glad you enjoyed it
excellent
really good job man.. thanks:)
good to understand!
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
EXCELLENT
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
Are you from Madagascar ? ^^
Hi there, I'm from the Philippines!
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)