Group based on slicer selection

[Hoping]

I would like to group rows and concatenate the values of a column depending on slicer selection.

My data looks like this:

The slicer selection is on Col2 and Col3

IF slicer selection is (Col2=All) i.e no filtering

IF slicer selection is (Col2=Group1)

How can I achieve this ?

[Anonymous · Accepted solution]

Hi @Hoping ,

I have created a simple sample, please refer to my pbix file to see if it helps you.

Create another with col2 in slicer.

Table 2 = SUMMARIZE('Table','Table'[col2])

Then create a measure.

Measure =
VAR _1 =
    SELECTCOLUMNS ( 'Table 2', "a", 'Table 2'[col2] )
RETURN
    CALCULATE (
        SUM ( 'Table'[col4] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[col2]
                IN _1
                    && 'Table'[col5=concatenated col2]
                        = SELECTEDVALUE ( 'Table'[col5=concatenated col2] )
        )
    )

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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