How to get row count using measure as a 'contains' filter

[Anonymous]

I have a table where I am trying to get a count of the # of tasks completed each quarter containing certain key words in the labels field. For example, for tasks containing the word 'Gov't Affairs' in the label, count the # of tasks completed each quarter with this key word. 

 

However, I wanted to create a slicer that allowed you to filter based off if the label 'contains' a key word. So I created a separate non-related table containing each of the labels and a measure that searches the 'Labels' column in my main table.

Using what I did above, I can get output like this:

However, I don't want to display the Labels column; I only want the quarter completed date and the # of tasks completed in each quarter. When I try to do this, I get nothing:

How can I get the output I got above, using my separate table and measure as a filter?

Also, is there anyway I am able to select multiple labels? Using the table as a slicer, I am only to select one label at a time.

[Anonymous]

Hi @Anonymous ,

Do you want to get the count of task which contains selected labels? In order to give you a suitable solution, could you please provide some sample data in your table PlannerBoardTasks_NODUPLICATES (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[Chew_WenJie]

Hi, instead of SEARCH i think you can use CONTAINS function for the selected labels. For example,

 IF(CONTAINS(PlannerBoardTasks,PlannerBoardTasks[Labels],SELECTEDVALUE([Labels])),COUNT([Labels]),"0")

Hope this can helps you.

[Anonymous]

This unfortunately does not solve my issue.