Clicking on cell in table should filter only on that cell, not on the entire row

[FrankvanDorp]

Consider the two tables below, both based on the same sample data:

When I click on a cell with "Canada" on the left, Power BI will filter the right table on based on the entire row I select, so not just on Country="Canada", but also on Date="1 september 2013" and Product="Paseo" and so on. It looks like this:

I want to change this, so that it only filters on the values in the CELL on which I click, not the entire ROW. So clicking on a cell with "Canada" should only filter on Country="Canada" but NOT on Date="1 september 2013", so the table on the right should just return all rows where Country="Canada", and not filter on date. Clicking on a cell with "1 september" should return all rows of the right table with Date="1 september" but include all countries. And so on.

How do I do this?

[dmf]

Hi curious if you found a solution to this?

[dmf]

Were you able to find a solution? I have the same issue. I want my table 2 to show all instances of a partial textstring in one cell of table 1 when I click anywhere on the row in table 1. 

I think I can use containsstring but don't know how to feed the data to search, I believe I might have to use a delimiter to split the column first isolating the text, then it becomes a simple find all instances of what i clicked.

[FrankvanDorp]

I still haven't found a solution to this problem, can anyone help me out?

[amitchandak]

@FrankvanDorp , It need a workaround, refer

Power BI Partial Interactions, Selectively pass filter across visuals - https://youtu.be/SFEKQEic_sk

[FrankvanDorp]

Apologies for the late reply.

I think this solution could bring me part of the way, but the problem is that I need to filter out different columns depending on what columns I click, there is no fixed column like Date in your example that always needs to be left out.

When I take your measure Net All Date = CALCULATE([Net], REMOVEFILTERS('Date')), and translate it to my example, I would need to apply REMOVEFILTERS('Date') when clicking on a Country, but I would need to apply REMOVEFILTERS('Country') when clicking on a Date cell.

So I would need some measure to apply the REMOVEFILTERS, but not always on the same column, instead it should look to the table, figure out what column is selected, and then apply it to all OTHER filters than the selected column. Is it possible to write a measure that does that?