DAX formula help self join

Question

Hi,&nbsp;I am trying to obtain below recordset using DAX formulas. How would get to it?&nbsp;Logic:Provider 1 is associated with Specialty A. So all the providers associated with A becomes RelatedProviders for 1 (1,2,3).Provider&nbsp;2 is associated with Specialty A and B. So all the providers associated with A and B&nbsp;becomes RelatedProviders for&nbsp;2 (1,2,3,4).Provider&nbsp;3 is associated with Specialty A. So all the providers associated with A becomes RelatedProviders for&nbsp;3 (1,2,3).Provider&nbsp;4 is associated with Specialty B. So all the providers associated with&nbsp;B becomes RelatedProviders for&nbsp;4 (2,4).&nbsp;Thanks.&nbsp;

liviolanzo · Accepted Answer

Does this do what you want?&nbsp;&nbsp;&nbsp;&nbsp;=GENERATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;VALUES&nbsp;(&nbsp;Providers[Provider]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;VAR&nbsp;Specialties&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CALCULATETABLE&nbsp;(&nbsp;VALUES&nbsp;(&nbsp;Providers[Specialty]&nbsp;)&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;RETURN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SELECTCOLUMNS&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CALCULATETABLE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;VALUES&nbsp;(&nbsp;Providers[Provider]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TREATAS&nbsp;(&nbsp;Specialties,&nbsp;Providers[Specialty]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALL&nbsp;(&nbsp;Providers[Provider]&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"RelatedProviders",&nbsp;[Provider]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;))

Forum Discussion

DAX formula help self join

1 Reply

Related content

If formula

formula

DAX Formula Help

DAX Formula

DAX Formula