topic Create calculation in a table based on column from another tbale in DAX Commands and Tips

Create calculation in a table based on column from another tbale

Anonymous — Mon, 05 Jun 2023 20:06:53 GMT

Hi,

I have two tables Table A and Table B which are joined by ID and have a many to one realtionship between A and B.

I need to create a calculated column in Table A based on some columns from Table B. I tried using the RELATED function which is giving me the below error, even though there is a relationship:

The column 'Table B[X]' either doesn't exist or doesn't have a relationship to any table available in the current context.

Any assistance appreciated.

Re: Create calculation in a table based on column from another tbale

lbendlin — Wed, 07 Jun 2023 00:15:42 GMT

Did you maybe set the filter direction from A to B?

Re: Create calculation in a table based on column from another tbale

Anonymous — Mon, 12 Jun 2023 13:15:16 GMT

I tried that, but it was not working as expected.

Re: Create calculation in a table based on column from another tbale

lbendlin — Mon, 12 Jun 2023 13:47:14 GMT

You shouldn't.

Please provide a sample PBIX that illustrates the issue.