Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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..!
Solved! Go to 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.
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..!
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..!