Forum Discussion
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 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
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!
2 Replies
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
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!
