Forum Discussion
AnandNamburi
Helper III
Helper IIIHow to create a relationship using DAX
Hi All, Lets assume that I have 3 tables like Table A, Table B & Table C. Table A and Table B are joined using a common key/field, but Table C is stand alone table and is not joined with any ...
Hi AnandNamburi ,
You need to create a measure to connect table A and Table C,such as below:
Measure = CALCULATE('Table A'[Measure from table A],FILTER(ALL('Table A'),'Table A'[Name]=MAX('Table C'[Name ])))And you will see:
For the sample .pbix file,pls see attached.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
v-kelly-msft
Community Support
Community SupportHi AnandNamburi ,
You need to create a measure to connect table A and Table C,such as below:
Measure =
CALCULATE('Table A'[Measure from table A],FILTER(ALL('Table A'),'Table A'[Name]=MAX('Table C'[Name ])))And you will see:
For the sample .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!