Selected value for multiple selection

[Syndicate_Admin]

Hello, good afternoon

I have a table more or less like that.

In the report I am doing it is required that you have a segmenter that shows the field master_restaurant_id and then another that shows master_product_id, of which the second segmenter should only show the products of the selected restaurant.

As I could not think of another way for the product segmenter to show only those of the selected restaurant (I have tables that have those values as unique but they are not related, but I did not know how to force only the products that the restaurant has to be shown) I put in the first segmenter the field master_restaurant_id and in the second the field master_product_id and edit the interactions so that the slicer of the product do not filter the restaurant.

So far so good (although if it can be done in a better way I would like to be told how) but now I need to get a data from another table that is not related that contains a specific url for each product, the way I had done this was with lookupvalue but for this I need to know the value that is being filtered as with selectedvalue, the problem is that the table where the slicers are has duplicate values of each product and so if I use selectedvalue it returns a blank value (or I think that's why), there is some way to know the list of values that are being selected or some other way to solve the problem I raise, I assumed that if I can get the list of values that are being selected as they should be the same but several times since it is only allowed to select a product I could use a distinction or summarize to leave only one and that use it in the lookupvalue although I am not sure that something like that can be done.

As far as you can help me, I will be very grateful.

[Anonymous]

Hi @Syndicate_Admin ,

I'm not quite sure if I understand your needs accurately. Would you mind telling me a more detailed description of your needs so that I can help you better?

Can you show us what you expect the output to be like?

Hope it helps,

Community Support Team _ Caitlyn

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

[Syndicate_Admin]

I would like to know if there is a way to know the selected values in a multiple selection slicer