Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Slicer issue - inner join effect

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 accountsProductspriceTrans_date
Customer 1Product A2008/3/2020
Customer 1Product B1008/3/2020
Customer 1Product C5008/3/2020
Customer 1Product D4008/3/2020
Customer 2Product E1008/3/2020
Customer 2Product A2008/3/2020
Customer 2Product B1008/3/2020
Customer 2Product C5008/3/2020

 

Business accounts:

Business accountsProductspriceTrans_date
Business 1Product A1008/3/2020
Business 1Product B6008/3/2020
Business 1Product C4448/3/2020
Business 1Product D3508/3/2020
Business 1Product G4508/3/2020
Business 1Product H4508/3/2020
Business 2Product I4508/3/2020
Business 2Product J4508/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..!

 

 

  • 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's avatar
    Anonymous
    6 years ago

    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..!

2 Replies

  • dax's avatar
    dax
    Community Support

    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's avatar
      Anonymous
      Not applicable

      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..!