Exclude results in a visual

[Tribunal]

New Power BI user here.  I've searched and found many topics about my issue but nothing seems to work (most likely I'm not understanding the logic needed).

I am working with vulnerability feeds.  I have a table that includes all vulnerabilities.  I have a visual already named "Vulnerabilities by Severity" that shows me how many are Critical, High, etc. of the whole population.

But now I'd like to create the same visual but exclude any row where the data in the DeviceName column starts with xyz-. 

In other words, if the table looks like this:

DeviceName	Description	Severity
Device1	asdf	High
Device2	asdf	High
xyz-Device3	asdf	High
Device4	asdf	High

I'd like a visual (for example, a Card) that would show the number of High vulnerabilities is 3, since row 4 starts with xyz-.

I know this is very basic.  When I'm new to something like this, it can take me a while to figure out the overall logic.  But once I get that ah-ha moment, I tend to be able to build on it and fire on all cylinders.  I just can't get that ah-ha moment right now no matter how many forums and YT videos I keep reviewing.  Most of them give me steps that it takes knowing BI jargon and I'm very new to this.

Thank you for any help, even if it's just teaching me to fish.

[Syk · Accepted solution]

You can create a filter for the visual.

If you need a card with the same filtering, you can set a filter to a card or just copy/paste the table and set it as a card instead.

You could also set another visual level filter to say only where severity is high to narrow it down further (when you add more data).

[_AAndrade · Accepted solution]

Hi @Tribunal,

Here is my solution:

Count High = 
CALCULATE(
    COUNTROWS(T_Severity),
    FILTER(
        ALL(T_Severity),
        T_Severity[Severity]="High" && LEFT(T_Severity[DeviceName],4) <> "xyz-"
    )
)

[Tribunal]

Thank you all!  I tried to mark all three as the solution because they all helped (I even used the query to help with another issue).

I knew it would be something basic but just learning that helped me complete my whole dashboard.  Thank you all!

[HotChilli · Accepted solution]

Create the card.  Drag a field on to the card and select your aggregation (or create your own measure and put that on).

Drag DeviceName into the Filters pane where it says 'Add data fields here'. Select Advanced Filtering and 'does not start with', put xyz in here

[_AAndrade · Accepted solution]

Hi @Tribunal,

Here is my solution:

Count High = 
CALCULATE(
    COUNTROWS(T_Severity),
    FILTER(
        ALL(T_Severity),
        T_Severity[Severity]="High" && LEFT(T_Severity[DeviceName],4) <> "xyz-"
    )
)

[Syk · Accepted solution]

You can create a filter for the visual.

If you need a card with the same filtering, you can set a filter to a card or just copy/paste the table and set it as a card instead.

You could also set another visual level filter to say only where severity is high to narrow it down further (when you add more data).