Forum Discussion

SHS's avatar
SHS
Resolver I
6 years ago
Solved

Filtered Row in Query Editor not applying to related Queries

Hello,   I have 2 queries - 1 containing account master data and 1 containing turnover data (with Account ID being the related column). In the account query I have filtered all inactive accounts. H...
General Comment
Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi SHS ,

     

    Yes ideally it should work fine.

    Is it possible for you to share your .pbix file after removing any sensitive information?

    Also, can you share screenshot of your data model with relationships between these tables here?

     

    If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

     

    Thanks,

    Pragati

Pragati11's avatar
Pragati11
Super User
6 years ago

Hi SHS ,

 

In edit query you will not see any cross-filtering between these 2 tables.

But when you create a visualisation, the data will get cross-filtered - so displaying only those with ACTIVE accounts.

Try moving your data to a visual and check.

 

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

 

Thanks,

Pragati

  • SHS's avatar
    SHS
    Resolver I
    6 years ago

    Hi Pragati, 

     

    Thank you for your quick support. 

     

    It seems to work on visuals like charts and diagrams, but it still shows the turnover data in a table, just with empty data in all account master data-related columns - isn't it supposed to be hided from tables as well? 

    • Pragati11's avatar
      Pragati11
      Super User
      6 years ago

      Hi SHS ,

       

      Yes ideally it should work fine.

      Is it possible for you to share your .pbix file after removing any sensitive information?

      Also, can you share screenshot of your data model with relationships between these tables here?

       

      If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

       

      Thanks,

      Pragati