Forum Discussion

gumis_rulez's avatar
gumis_rulez
Icon for Helper I rankHelper I
2 years ago
Solved

Getting customers ids based on another dimension table

I have following model:     i want to create following page:   By choosing on the slicer salesperson_id which comes from dimension table dimEmployee, I want to show all customer_id f...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi gumis_rulez 

     

    Thanks for the reply from ray_codex , please allow me to provide another insight:

     

    gumis_rulez , do you need the table to display data based on the options selected in the slicer? If I understand correctly, please refer to the following test.

     

    You can change the Cross-filter direction of the dimCustomer table and fctSales table to both.

     

    Output:

     

    Best Regards,
    Yulia Xu

     

    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
2 years ago

Hi gumis_rulez 

 

Thanks for the reply from ray_codex , please allow me to provide another insight:

 

gumis_rulez , do you need the table to display data based on the options selected in the slicer? If I understand correctly, please refer to the following test.

 

You can change the Cross-filter direction of the dimCustomer table and fctSales table to both.

 

Output:

 

Best Regards,
Yulia Xu

 

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