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

Cross filtering in relationships

Can someone please explain me about cross filtering option in relationships in a simple way? Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Solution Sage
Solution Sage

Re: Cross filtering in relationships

Hi @ShivaPrasad1

 

In a simple way : 

 

I have 'A table' and 'B table'.

A table is my sales and B table is my clients

 

If I use only one direction filter from A to B, it means that if I choose a product sold in Table A, I will see the clients that bought the product in B. But if I want to choose one client in B and see what he bough for example, I can't, because I will need bi directionnal filter.

 

I hope you understand.

The best way to understand it, it's to try with data of yours.

 

And if you are wondering wich one to choose in your relation, just think about "Wich one will filter the other one ?" 

 

- Quentin

View solution in original post

3 REPLIES 3
Highlighted
Solution Sage
Solution Sage

Re: Cross filtering in relationships

Hi @ShivaPrasad1

 

In a simple way : 

 

I have 'A table' and 'B table'.

A table is my sales and B table is my clients

 

If I use only one direction filter from A to B, it means that if I choose a product sold in Table A, I will see the clients that bought the product in B. But if I want to choose one client in B and see what he bough for example, I can't, because I will need bi directionnal filter.

 

I hope you understand.

The best way to understand it, it's to try with data of yours.

 

And if you are wondering wich one to choose in your relation, just think about "Wich one will filter the other one ?" 

 

- Quentin

View solution in original post

Highlighted
Helper I
Helper I

Re: Cross filtering in relationships

Thank you @quentin_vigne. This is really helpful example to understand.

Highlighted
Solution Sage
Solution Sage

Re: Cross filtering in relationships

@ShivaPrasad1

 

You're welcome

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.