How to create a relationship using DAX

[AnandNamburi]

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 other tables.

In a visual, If I'm going to show a column from Table C and a measure from table A, then I'm getting constant values which is summarized at the table level. Is there any way to group the value based on the column from A without any active relationship.

Thanks,

Anand

[v-kelly-msft · Accepted solution]

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]

@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