Forum Discussion

AnandNamburi's avatar
AnandNamburi
Icon for Helper III rankHelper III
5 years ago
Solved

How 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 ...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    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,
    Kelly

    Did I answer your question? Mark my post as a solution!

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

AnandNamburi , You have to filter it in measure.

 

calculate(sumx(values(TableC[ID]), calculate(Sum(TableC[Value]))), filter(TableC, TableC[ID] = max(TableA[ID])))

 

Best is you refer to segmentation video, where we use independent table: https://www.youtube.com/watch?v=CuczXPj0N-k