Forum Discussion

Tribunal's avatar
Tribunal
Regular Visitor
2 years ago
Solved

Exclude results in a visual

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. ...
  • Syk's avatar
    2 years ago

    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's avatar
    2 years ago

    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-"
        )
    )
  • HotChilli's avatar
    2 years ago

    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