filter table below based on DAX measure

[WTAS80486]

I have a table on a report with columns ID, site, GM. Two graphs on the same page which should show clustered bar graph with total count of ID without GM by different sites and total count of ID with GM by different sites. now when I select a site bar (ex: ABC) on 'total count of ID without GM' graph with total ID without GM 25k, then the table below should only show those IDs which do not have any GM for site ABC

So, in the below visual when i select first bar in ID without GM it should show only blank GM rows for the site selected (ABC)

[Anonymous · Accepted solution]

HI @WTAS80486,

I'd like to suggest you write a measure formula with conditions to compare with current row count and return flag.
After these steps, you can use this on the visual level filter to filter records based selections.

Applying a measure filter in Power BI - SQLBI

If you are confused about coding formula, can you please share some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng