Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Use slicer to a filter table based on values in multiple columns

I am very new to Power BI and DAX in general so please forgive me:   So the context of the story is: I have conducted a survey where there were questions with free text I've then created a table...
General Comment
Need Help
Show and Tell
Tutorial Requests
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Anonymous,

     

    Make the relationship inactive between these two tables and add measure below. It takes advantage of Show Categories With No Data.

    Measure =
VAR t =
    VALUES ( THEMES[Category] )
RETURN
    IF (
        COUNTROWS (
            FILTER (
                COMMENTS,
                COMMENTS[Category 1] IN t
                    || COMMENTS[Category 2] IN t
                    || COMMENTS[Category 3] IN t
            )
        )
            > 0,
        1
    )
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

Anonymous,

 

Make the relationship inactive between these two tables and add measure below. It takes advantage of Show Categories With No Data.

Measure =
VAR t =
    VALUES ( THEMES[Category] )
RETURN
    IF (
        COUNTROWS (
            FILTER (
                COMMENTS,
                COMMENTS[Category 1] IN t
                    || COMMENTS[Category 2] IN t
                    || COMMENTS[Category 3] IN t
            )
        )
            > 0,
        1
    )