Select an item on a table and have other elements not filter using all filters appled to that table

[DavidNW]

Hello,

I am still pretty new to PowerBI and I have run into something I am not sure if possible and can't find a solution to on here already!

I am going to try and be detailed enough but I hope I make sense!

My data set includes a list of authors who work for 'firms' and has separate rows for how many articles they discuss a topic and then an additional row that is an overall; this is because they may discuss multiple topics in one article, so if I just simply summed all the individual topics the number would be much higher than the actual number of articles there were, so the overall row de-duplicates this so you get the actual number of articles. 

So a basic example would be:
Firm                 Author              Topic                         Articles

----------------------------------------------------------

ChangeIT         Joe Bloggs        AI                             2

ChangeIT         Joe Bloggs        Infrastructure           2

ChangeIT         Joe Bloggs        OVERALL                  3

In this example there was one article which discussed both of the topics and then each topic had a unique article so the total is 3.

So here is the issue, I have a table in my PowerBI dashboard which lists the Firms and then has column with other info which I have filtered to just show me the OVERALL figures as this is the deduplicated figure.

My problem is I then have a graph that shows me the volumes for the topics themselves, excluding the overall.

What I wanted was to be able to click on one of the firms in my table and have the graph update to show me the topics that firm has written about, but because the table is filtered to be only topic-Overall the graph goes blank because I have excluded this topic from the graph as I only want the individual topics shown.

Is there a way to have the graph ignore the filter on the table when I select an item from the table. ie) I click and it knows to filter the firm but to ignore any other filters on the table for other elements on the dashboard.

I really hope this makes sense and thank you for your time if anyone can help!

David

[mwegener · Accepted solution]

Hi @DavidNW ,

Move the filtering from the visual to a measure.

Articles (overall) = CALCULATE(SUM('Table'[Articles]),'Table'[Topic] = "OVERALL")