How to remove data values that contain a legend category?

[jb2019]

I have a clustered bar chart and I am trying to remove the data points that contain a specific legend category.

NOTE - this is not simply filtering out the legend category. 

Here is the table view for the chart. I am trying to remove the rows that contain a value in the "Foundation" column. For these rows, this would result in just the second and last row remaining in the table/chart. 

[v-easonf-msft · Accepted solution]

Hi ， @jb2019 

Try to create another measure as below:

Visaul control =
COUNTROWS (
    FILTER (
        ALL ( 'Table' ),
        'Table'[Product & Brand] = MAX ( 'Table'[Product & Brand] )
            && [Certification Tier] = "Foundation"
    )
)

Then drag it to the visual filter pane to filter out rows that do not contain any value in the "Foundation" column.

Please check my sample file for more details.

Best Regards,
Community Support Team _ Eason

[smpa01]

@jb2019you can remove it like this

[jb2019]

Foundation is one of three values under "Certification Tier" which is used for the legend. How can I pull out Foundation so that I can filter it?

[smpa01]

@jb2019you need to write a measure that takes out the blank Foundation rows

e.g