cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Join kind in relationships view?

Hi all, 

 

I have a lot of tables from my data base and relationships -view is showing relationships between them.

 

I am having an issue with two tables - one is "contract" and the other "product on contract".

 

"Contract" is filtered on query to contain only the active contracts. And obviously I would like the  "product"-table behave the same if used in visuals.

 

What would be tha smart solution here? I have a lot of tables in my relationships and cannot marge them into one in queries there join kind can be defined.

 

Jenni

 

 

2 REPLIES 2
Highlighted
Microsoft
Microsoft

Re: Join kind in relationships view?


@dhannaa wrote:

Hi all, 

 

I have a lot of tables from my data base and relationships -view is showing relationships between them.

 

I am having an issue with two tables - one is "contract" and the other "product on contract".

 

"Contract" is filtered on query to contain only the active contracts. And obviously I would like the  "product"-table behave the same if used in visuals.

 

What would be tha smart solution here? I have a lot of tables in my relationships and cannot marge them into one in queries there join kind can be defined.

 


@dhannaa

You can also apply filter on query to contain only active contracts for "prodct on contract" and then just create a simple one-many relationship. If it is not possible, could you post any sample data of those two tables and expected output?

Highlighted
Helper III
Helper III

Re: Join kind in relationships view?

Thank you for your response @Eric_Zhang.

 

Just to clarify, what do you exactly mean? Information whether the contract is active or is only on "contract"-table. Do you mean I should merge this information to "product on contract"-table and then filter out the lines with inactive contract information?

 

Or is there a better way I don't figure out?

 

Jenny

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors