Have column with multiple values in powerBI for use with a slicer in power bi

Question

I have a column with the following data

basketball
football
basketball and football

I would like to add a slicer to this which has two options - basketball, football. If i ask for basketball, I should be getting all basketball entries from all three columns. Is this possible?

Answer 1

It can be achieved depending on the result you want to show for the filtered rows, e.g, a sum, average, count, etc.

I will show you a very simple example of a sum for the filtered rows by using the SUMX function available in DAX expressions.

Sport	Value
Basketball	4
Football	11
Basketball & Football	9

Sliver column:

Basketball

Football

Add this code:

Result =
SUMX (
    FILTER (
        MyTable,
        [Sport] = FIRSTNONBLANK ( SlicerTable[SlicerColumn], 0 )
            || FIND ( FIRSTNONBLANK ( SlicerTable[SlicerColumn], 0 ), [Sport], 1, -1 ) > -1
            || NOT ISFILTERED ( SlicerTable[SlicerColumn] )
    ),
    [Value]
)

Comments

Thanks a lot :)