This Power Bi file has used both Related and RelatedTable functions in DAX with a fictitious dataset. The following video link explains the same in detail : https://www.youtube.com/watch?v=eQSbslcqfUs