Forum Discussion
Helper IGetting 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 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
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 XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- ray_codex
Resolver II
Put a filter on your visual solves this:
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 XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
