Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

loop over multiple select slicer

Hi everyone  Here is my problem. I have a table (LDM LIVE) with a summary,labels and description columns with a slicer (Part number) from another table (EPICOR LIVE). I need to find if the slicer va...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 
    Please try

    IsContained =
IF (
    NOT ISEMPTY (
        FILTER (
            'LDM live',
            NOT ISEMPTY (
                FILTER (
                    ALLSELECTED ( 'EPICOR LIVE'[Part number] ),
                    CONTAINSSTRING ( 'LDM live'[Summary], 'EPICOR LIVE'[Part number] )
                        || CONTAINSSTRING ( 'LDM live'[Description], 'EPICOR LIVE'[Part number] )
                        || CONTAINSSTRING ( 'LDM live'[Labels], 'EPICOR LIVE'[Part number] )
                )
            )
        )
    ),
    1
)
  • tamerj1's avatar
    tamerj1
    3 years ago

    Anonymous 

    Please try

    IsContained =
IF (
    COUNTROWS ( ALLSELECTED ( 'EPICOR LIVE'[Part number] ) )
        <> COUNTROWS ( ALL ( 'EPICOR LIVE'[Part number] ) ),
    IF (
        NOT ISEMPTY (
            FILTER (
                'LDM live',
                NOT ISEMPTY (
                    FILTER (
                        ALLSELECTED ( 'EPICOR LIVE'[Part number] ),
                        CONTAINSSTRING ( 'LDM live'[Summary], 'EPICOR LIVE'[Part number] )
                            || CONTAINSSTRING ( 'LDM live'[Description], 'EPICOR LIVE'[Part number] )
                            || CONTAINSSTRING ( 'LDM live'[Labels], 'EPICOR LIVE'[Part number] )
                    )
                )
            )
        ),
        1
    )
)
Anonymous's avatar
Anonymous
Not applicable
3 years ago

tamerj1 What if I don't want the table to show anything if nothing is selected in the slicer ? 

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    Anonymous 

    Please try

    IsContained =
IF (
    COUNTROWS ( ALLSELECTED ( 'EPICOR LIVE'[Part number] ) )
        <> COUNTROWS ( ALL ( 'EPICOR LIVE'[Part number] ) ),
    IF (
        NOT ISEMPTY (
            FILTER (
                'LDM live',
                NOT ISEMPTY (
                    FILTER (
                        ALLSELECTED ( 'EPICOR LIVE'[Part number] ),
                        CONTAINSSTRING ( 'LDM live'[Summary], 'EPICOR LIVE'[Part number] )
                            || CONTAINSSTRING ( 'LDM live'[Description], 'EPICOR LIVE'[Part number] )
                            || CONTAINSSTRING ( 'LDM live'[Labels], 'EPICOR LIVE'[Part number] )
                    )
                )
            )
        ),
        1
    )
)