Getting customers ids based on another dimension table

[gumis_rulez]

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 from another dimension table dimCustomers. I have managed to create a measure which shows number of customers:

test = 
CALCULATE(
    DISTINCTCOUNT(
        dimCustomer[customer_name]
    ),
    CROSSFILTER(
        fctSales[customer_id], dimCustomer[customer_id], Both)
)

but how to receive a list of customers to use in matrix?

https://drive.google.com/file/d/1t1aXOMxzGNdLFCVuDi8eMv2-bo9w7tcQ/view?usp=sharing 

[Anonymous · Accepted solution]

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.

[ray_codex]

Put a filter on your visual solves this: