Number of values, despite multiple selection in data source

[Benedikt42]

Hello all,

I have not been working with Power BI Desktop for long, but I am now facing a problem.

In my Power BI, a database is used as a data source.

In the database, I enter persons and values or I can click on values. In a certain input field, I can select several values at the same time.

In Power BI, I want to count how many times a value has been selected in total, but the exact selection in the field in Power BI is currently selected at the individual persons.

This then looks like this:

As you can see, some terms show up on multiple bars.

Can you help me how to count only the individual terms, how often they were selected in general?

Here is an example of how it should look:

Thank you very much for your help.

Many greetings

Benedikt

[Benedikt42]

Thank you @v-luwang-msft, that was really helpful.

[v-luwang-msft · Accepted solution]

Hi @Benedikt42 ，

In Power BI, when using the slicer, you can also select multiple values, hold down the ctrl value, and then click on the selected value in the slicer.

refer:

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien