get distinct value of table column based on a slicer selected value

[Maghed]

If I select a Brand from slicer, I need to create a new table with Distinct values of colmun color ie:

reult will be a new calculated table with 3 colors Red,Green, Blue

Thank you

[v-xiaosun-msft · Accepted solution]

Hi @Maghed ，

According to your description, I created a sample and here is my solution.

Firstly, you can create a new table by using SUMMARIZE function to reference the "color" column.

Table_summarize =
SUMMARIZE ( 'Table', 'Table'[Colors] )

Then, create a measure to connect with the slicer.

control =
VAR _slice =
    SELECTEDVALUE ( 'Table'[Brand] )
RETURN
    IF (
        COUNTROWS (
            FILTER (
                'Table',
                SEARCH ( MAX ( 'Table_summarize'[Colors] ), MAX ( 'Table'[Colors] ),, -1 )
            )
        ) > 0,
        1,
        BLANK ()
    )

Remember to establish a relationship between two tables.

Then you will get the expected output.

And I've also created an additional example to give you a clearer view of how the formula works.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ xiaosun

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

[Maghed]

Great Support. Thank you ✌️