Slicer issue - inner join effect

[Anonymous]

Hi All,

I have a requirement where i have to display prices and totals of products from two tables  Customer accounts and Business accounts. each customer account has some products and each business also have some products associated. i cannot drop products under each of these accounts while showing prices, Since there will be multiple business and customer accounts user will pick and chose a single customer account against single business account of his choice to compare the prices for a given day.

Issue: When a slicer is used to select a Business account and Customer account, i see only common products between the two accounts (acts like inner join).

Model

 

Expected result 

 

Data:

Customer accounts:

Customer accounts	Products	price	Trans_date
Customer 1	Product A	200	8/3/2020
Customer 1	Product B	100	8/3/2020
Customer 1	Product C	500	8/3/2020
Customer 1	Product D	400	8/3/2020
Customer 2	Product E	100	8/3/2020
Customer 2	Product A	200	8/3/2020
Customer 2	Product B	100	8/3/2020
Customer 2	Product C	500	8/3/2020

Business accounts:

Business accounts	Products	price	Trans_date
Business 1	Product A	100	8/3/2020
Business 1	Product B	600	8/3/2020
Business 1	Product C	444	8/3/2020
Business 1	Product D	350	8/3/2020
Business 1	Product G	450	8/3/2020
Business 1	Product H	450	8/3/2020
Business 2	Product I	450	8/3/2020
Business 2	Product J	450	8/3/2020

Products master:

Products

Product A

Product B

Product C

Product D

Product E

Product F

Product G

Product H

Product I

Product J

Time dim:

Date

8/1/2020

8/2/2020

8/3/2020

8/4/2020

8/5/2020

 I cannot use a cross join of products with customer accounts and business accounts in the real scenario due to data volume and other measures related complexities, I appriciate your help..!

Thank you..!

[dax · Accepted solution]

Hi @Anonymous , 

You could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dax · Accepted solution]

Hi @Anonymous , 

You could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi Zoe,

Awesome, Thanks for the help, could you tell me how did you do this ?

The relationships looks the same as mine ?

Would you please explain the resolution, is it cross-filter direction suppose to be single ?

Thank you..!