Filter table

[dominik_thoe]

Hello,

I have to table visuals based on the same table (Account).

Structure first visual

Account, Classification, Segment, Parent Account

Structure second visual

Parent Account, Account, Classification, Segment

I want to filter the second visual by the Parent Account that I select in the first visual to see all accounts that are linked to the Parent Account including their assigned Classification/Segment. The standard function filters the second visual with all objects, not only the Parent Account. 

Any idea how I can solve this?

thanks

Dominik

[v-easonf-msft · Accepted solution]

Hi， @dominik_thoe 

I create a sample pbix file,please check it for  more details.

In order to avoid cross filtering of fields in a table, you need to copy the table to create another independent  table visual.

Then create a visual control measure and  drag it to table visual filter pane to filter data.

Visual control = 
VAR flag =
    IF (
        SELECTEDVALUE ( 'Table copy'[Parent Account] )
            = SELECTEDVALUE ( 'Table1'[Parent Account] ),
        1,
        0
    )
RETURN
    IF ( ISFILTERED ( Table1[Parent Account] ), flag, 1 )

The result will show as below:

Best Regards,
Community Support Team _ Eason

[dominik_thoe]

Hello @v-easonf-msft 

thanks for your help!!

[PaulDBrown]

@dominik_thoe 

Can you please show a depiction of the model you have, and how the tables are related?

Can you please also read this important post?
How to get your question answered quickly 
thanks

[dominik_thoe]

Hi Paul.

I use only one table: Account. Data from connected tables is not used in the visual.

I want to filter the second table by the parent account only and not by classification, segment and frequency to display all accounts with parent account 1004969 (see grren box).

Hope this helps.

thanks