topic Re: Getting customers ids based on another dimension table in DAX Commands and Tips

Getting customers ids based on another dimension table

gumis_rulez — Wed, 04 Sep 2024 11:22:04 GMT

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

Re: Getting customers ids based on another dimension table

ray_codex — Wed, 04 Sep 2024 12:55:07 GMT

Put a filter on your visual solves this:

Re: Getting customers ids based on another dimension table

Anonymous — Thu, 05 Sep 2024 03:16:43 GMT

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.