Filtering a column by single value which contains multiple options

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.