Filter table from visual on only one column not all?

[OneWithQuestion]

I have a map visual and I am plotting the most recent event by location.

That works great, I have a filter "Is Most Recent Event" and I place that on the map visual filter with =YES.

However, I want to display a table under the map showing ALL events for the selected map location.

When I click on a point on the map it filteres the table for that location, but it also filters it on the "Is Most Recent Event" = YES.

I instead want to see all the events for that selected map location.

Is there a way I can control what values are used to cross filter on visuals?

EDIT: Clarification -

I tried adjusting the visual interactions as described here: https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions  However, that does not work in my case as I do not want to STOP all interaction, I just want to specifically select which columns are used when cross filtering.

[Anonymous]

Hello - did you ever find a solution to this? I am trying to achieve the same functionality but am not seeing how the posted solution accomplishes that. Thanks.

[v-frfei-msft · Accepted solution]

Hi @OneWithQuestion,

I made one sample for your refernce. Please check the following steps as below.

1. Create a calculated table.

new = CALCULATETABLE(Table1)

2. To create a table visual using the calculated table. After that we need to Create a measure as below and filther the table visual using the new measure.

Measure = var con = SELECTEDVALUE(Table1[construction]) 
var cons = MAX(new[construction])
return
IF(ISBLANK(con),1,IF(con=cons,1,0))

For more details, please check the pbix as attached.

Regards,

Frank

[v-frfei-msft]

Hi @OneWithQuestion,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,
Frank