Table visual selections that act as disconnected filters?

[Heather101]

So I have the below table that is a result of a bridge between top level log and associated logs tables.

 Top level log Id   Associated log id

12348                      93837

27368                      83636

Each table is linked to its own respective log entry table where an id is related to multiple log lines.

What my end user wants is to be able to select either top level log Id  OR associated log Id  (in the table visual)

and get the resulting log entries.(But not both entries at the same time). Basically they want a related table visual to filter selections as if they aren't related. Is this possible?

[v-lili6-msft]

hi, @Heather101 

You may try to create a measure and then use it as a visual level filter to get it.

Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

lin

[Heather101]

ok, I will try but I dont know how to make it any clearer.

 sample data

Top level log Id	Associated log id
12348	93837
27368	83636

When I click any cell, I want to return log entries for ONLY that ID.

Normally what will happen is if i click 12348 in a table visual in powerbi it will filter to where top level log id=12348 and associated id =93837. I just want it to ONLY return rows where  top level log id=12348.

Log ID	Log Entries
12348	Json Output Error: UNKNOWN…
12348	Starting Job
12348	Job completed

[v-lili6-msft]

hi, @Heather101 

If you could this way:

Create another two tables: Dim Top level log Id table, Dim Associated log id table.

Then create relationship with this table and set cross filter direction is "single"

Then use this two dim table as filter.

Best Regards,

Lin