topic Re: Managing Relationships in DAX Commands and Tips

Managing Relationships

Anonymous — Mon, 30 Dec 2024 19:47:21 GMT

Hello,

I am not able to connect the Program columns below:

And:

I get this message:

Any suggestions?

Thank you!

Re: Managing Relationships

lbendlin — Mon, 30 Dec 2024 20:35:32 GMT

Can you please explain why you have duplicate rows in the second table?

What is your expected outcome?

Re: Managing Relationships

Anonymous — Mon, 30 Dec 2024 21:47:52 GMT

it's because we need the data for 2022 and 2024 and for many different program areas

Re: Managing Relationships

lbendlin — Mon, 30 Dec 2024 21:58:44 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Managing Relationships

Anonymous — Tue, 31 Dec 2024 00:03:41 GMT

Unfortunately I can't upload my file...

Re: Managing Relationships

lbendlin — Tue, 31 Dec 2024 00:17:08 GMT

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Re: Managing Relationships

Anonymous — Tue, 31 Dec 2024 02:22:40 GMT

Hi Anonymous ,

Usually we create a bridge table to create a relationship between two tables:

ProgramTable = DISTINCT( UNION( SELECTCOLUMNS('WES - Scores', "Program", 'WES - Scores'[Program]), SELECTCOLUMNS('Respectful Environment', "Program", 'Respectful Environment'[Program]) ) )

Many-to-many relationship guidance - Power BI | Microsoft Learn

Then use the fields in the bridge table.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data in the Power BI Forum

Re: Managing Relationships

Anonymous — Mon, 06 Jan 2025 22:45:24 GMT

Thank you so much! It works. Do you know how I can "tidy up" these relationship? I am not sure how to move the boxes at the very top of the page (it doesn't show as they are all the way up). I highlighed in yellow:

Re: Managing Relationships

Anonymous — Tue, 07 Jan 2025 01:48:43 GMT

Hi Anonymous ,

Try clicking the Fit to page button in the bottom right corner of the page and dragging the table into place.

Best Regards,
Gao
Community Support Team

Re: Managing Relationships

Anonymous — Thu, 09 Jan 2025 00:21:50 GMT

Unfortunately it dind't work. Are there other options?

Thanks!

Re: Managing Relationships

lbendlin — Thu, 09 Jan 2025 00:54:13 GMT

Click the button to the left of the "fit to page" one.

Re: Managing Relationships

Anonymous — Thu, 09 Jan 2025 16:54:45 GMT

That works, thanks so much!