Measure with the list of customer selected in the filter

[dobregon]

Hi,

I have a doubt related to filters/slicers. Now i have 3 tables as an example:

1. Table with Customer
2. Table with markets per customer
3. Table with values from markets

and the relationship is 1 to 3 and 2 to 3 and i can't change due to this is the form to have single relationship one to one.

The problem is that i want to have a list of metadata from the markets depends of the customer selection. So i have an slicer/filter with the list if customers in order to select 1, 2 or all customers and then the visual need to be filtered but as the 1 and 2 tables doesn't have a direct relationship (exist but there are some options that i can't use).

I'm finding something 2 measures:

- one measure that takes the list of customerids that are filtered.

- final measure that compare the customerids filtered in the slicer (rembmeber table 1) with the customerids in the table 2, in order to filter when they match.

I have the solution when I filter only one customerid, the problem is when i select more than one becasue the measure send me an error becasue it is not a unique value

Is that possible?

[tex628]

Can't you simply by assigning crossfilter direction "Both" on your two relationships? That should make it so that any filtering you do to the customer-table also filters the market-table.

[dobregon]

thanks for the reply @tex628  but it can't do that because there isn'ta possible relation. for that i'm trying the otther solutions but i can do only when i filter only one customer, if filter morde than one... big error jaja

[tex628]

Would you mind posting a picture of your table relationships?

[dobregon]

@tex628 thanks for the reply. I can't do a relationship becasue there are 2 relationship between 3 tables and one doesn't mach becasue has nulls. I will resolve that in my SQL so, the problem will be solved.

But apart of that i'm focused in to find a measure that can make me a list of customers selected in the slicer. I have solved for one using calculate (max(customer[customerid])allselected(customer[customerid]) but when i filtered in the slicer for more than one customer the measure is wrong becasue there is only unique value.