Forum Discussion

dominik_thoe's avatar
dominik_thoe
Frequent Visitor
5 years ago
Solved

Filter table

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, C...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    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's avatar
dominik_thoe
Frequent Visitor
5 years ago

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