Forum Discussion

BalazsNy's avatar
BalazsNy
Helper I
1 year ago
Solved

Filtering a column by single value which contains multiple options

Hi All, I have a report with 2 tables: The 1st collects Feedbacks of employees within company (imported from a SP list). These feedbacks can have single or multiple categories (in case of multi...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi BalazsNy ,

    Thanks for MFelix's reply!
    And BalazsNy , you can try this way:
    Use this DAX to create a measure:

    Filter = 
VAR SelectedWords = VALUES('Category'[Submission category])
RETURN
SUMX(
    'Feedbacks',
    IF (
        COUNTROWS(
            FILTER(
                SelectedWords,
                CONTAINSSTRING([category], [Submission category])
            )
        ) > 0,
        1,
        0
    )
)

    Then set it up as shown below:

    And the final output is as below:


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

BalazsNy's avatar
BalazsNy
Helper I
1 year ago

Thank you MFelix , basically the category filter works on it's own, but if any other filter is applied (e.g. date filter), that also ruins this measure, and category is not filtered anyomre...

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi BalazsNy ,

Thanks for MFelix's reply!
And BalazsNy , you can try this way:
Use this DAX to create a measure:

Filter = 
VAR SelectedWords = VALUES('Category'[Submission category])
RETURN
SUMX(
    'Feedbacks',
    IF (
        COUNTROWS(
            FILTER(
                SelectedWords,
                CONTAINSSTRING([category], [Submission category])
            )
        ) > 0,
        1,
        0
    )
)

Then set it up as shown below:

And the final output is as below:


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

  • BalazsNy's avatar
    BalazsNy
    Helper I
    1 year ago

    Thank you Anonymous This is a perfect solution.