Displaying relevant column values based on slicer selection.

[DeepakJha23]

Hi Power BI Community,

We are working on a requirement where we want to display the relevant values of column 2 based on the slicer selection made in column 1. Also, the slicer selection is multi select so it should show ALL in the card box when no selection is made.

See the image below for more details :

In the above slicer, ALL is selected but the display card shows the default first value(A) instead it should show ALL.

If the slicer is changed to 1, the display card should show A,B.

If the slicer is multi selected to 1,2 display card should change to A,B,C,D.

I would appreciate any help on this.

Thanks,

Deepak

@amitchandak @Sahir_Maharaj @lbendlin 

[lbendlin]

[DeepakJha23]

@lbendlin Thanks for responding.

Unfortunately, it worked on the sample data how you have posted above but when I tried this on the actual data the display card is showing repeated values.

Like if I select 1 in the column1 slicer , display card is showing A,A,A,A,A...... instead it should only show A.

We have long string values in column 2.

[Ahmedx]

write like this

Display = 
           IF(ISFILTERED('Table'[Column 1]),
           CONCATENATEX(SUMMARIZE('Table','Table'[Column 2]),'Table'[Column 2],","),
            "ALL"
                )

[lbendlin · Accepted solution]

Please provide sample data that covers your issue or question completely.

Display = if(isfiltered('Table'[Column 1]),CONCATENATEX(VALUES('Table'[Column 2]),[Column 2],","),"All")

[DeepakJha23]

@lbendlin Thanks. Using the VALUES solved the issue. Really appreciate your help.

[Ahmedx]

Is this what you are looking for?

[DeepakJha23]

@Ahmedx 

Thanks for responding on this query.

I tried the DAX you have suggested but due to the 4th line of DAX Table1[column1] = 1, this gave the below error :

The column 1 in my data is text data type.

[Anonymous]

Hi @DeepakJha23 

Try this one Solved: Concatenate distinct values from column in Measure - Microsoft Power BI Community